# mysql\_users SHOW VIEW permission not granted.

**URL:** <https://forum.ansible.com/t/mysql-users-show-view-permission-not-granted/26309>\
**Category:** Ansible Project\
**Created:** [December 15, 2017, 11:11pm UTC](https://forum.ansible.com/t/mysql-users-show-view-permission-not-granted/26309 "2017-12-15T23:11:22Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Colin\_Byrne](https://avatars.discourse-cdn.com/v4/letter/c/ecd19e/32.png) [@Colin\_Byrne](https://forum.ansible.com/u/Colin_Byrne)\
**Post date:** [December 15, 2017, 11:11pm UTC](https://forum.ansible.com/t/mysql-users-show-view-permission-not-granted/26309/1 "2017-12-15T23:11:22Z")

</div>

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.