mysql_user EXECUTE ON PROCEDURE

[Lance Onken]

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 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,

[Lance Onken]

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