I am struggling to set the SHOW VIEW permission for a user on a DATABASE.
I have tried with the following syntax, to no avail:
mysql_user:
name: "{{ <my username> } }"
password: "{{ <my password> } }"
priv: "<my_database>.*:SELECT,SHOW VIEW"
host: "{{ <my host> }}"
I am not sure what else to try!
Thanks in advance for any help.