# mysql\_user EXECUTE ON PROCEDURE

**URL:** <https://forum.ansible.com/t/mysql-user-execute-on-procedure/22204>\
**Category:** Ansible Project\
**Created:** [August 3, 2016, 4:28pm UTC](https://forum.ansible.com/t/mysql-user-execute-on-procedure/22204 "2016-08-03T16:28:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lance\_Onken](https://avatars.discourse-cdn.com/v4/letter/l/5f8ce5/32.png) [@Lance\_Onken](https://forum.ansible.com/u/Lance_Onken)\
**Post date:** [August 3, 2016, 4:28pm UTC](https://forum.ansible.com/t/mysql-user-execute-on-procedure/22204/1 "2016-08-03T16:28:30Z")

</div>

Hello, I’d like to grant EXECUTE ON to a single stored PROCEDURE.

```auto

```

```auto

priv=*.*:SELECT/mydb.get_readings:EXECUTE

```

```auto

'Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used'

```

MySQL documentation indicates the correct syntax would be:

`priv=*.*:SELECT/mydb.get_readings:"EXECUTE ON PROCEDURE"`

```auto

```

```auto
Which gives the expected error since [VALID_PRIVS](https://github.com/ansible/ansible-modules-core/blob/devel/database/mysql/mysql_user.py#L170) does not contain "EXECUTE ON PROCEDURE"

```

```auto

"msg": "invalid privileges string: Invalid privileges specified: frozenset(['\"EXECUTE ON PROCEDURE\"'])"

```

```auto
I am able to grant EXECUTE on wildcard:

```

```auto

priv=*.*:SELECT/mydb.*:EXECUTE

```

```auto

```

```auto
Thanks,

```

```auto

```

```auto

```

```auto

```

```auto

```

---

<div class="post-metadata">

**Author:** ![Lance\_Onken](https://avatars.discourse-cdn.com/v4/letter/l/5f8ce5/32.png) [@Lance\_Onken](https://forum.ansible.com/u/Lance_Onken)\
**Post date:** [August 4, 2016, 8:44pm UTC](https://forum.ansible.com/t/mysql-user-execute-on-procedure/22204/2 "2016-08-04T20:44:17Z")

</div>

A Feature Idea Issue has been reported: [https://github.com/ansible/ansible-modules-core/issues/4328](https://github.com/ansible/ansible-modules-core/issues/4328)