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: “{{ } }”
password: “{{ } }”
priv: “<my_database>.*:SELECT,SHOW VIEW”
host: “{{ }}”
`
I am not sure what else to try!
Thanks in advance for any help.