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, -- You received this message because you are subscribed to the Google Groups "Ansible Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/44e9c067-1fca-4dc4-b864-7d5852dc2404%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
