mysql_user EXECUTE ON PROCEDURE

Archives Ansible Project
1

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




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



'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"



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"


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


I am able to grant EXECUTE on wildcard:



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




Thanks,
2

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