mysql_users SHOW VIEW permission not granted.

10 views
Skip to first unread message

colin byrne

unread,
Dec 15, 2017, 6:11:22 PM12/15/17
to Ansible Project
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. 

Reply all
Reply to author
Forward
0 new messages