A Feature Idea Issue has been reported: https://github.com/ansible/ansible-modules-core/issues/4328
On Wednesday, August 3, 2016 at 10:51:57 AM UTC-7, Lance Onken wrote: > > 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/7f38d95a-404d-4f31-8da5-0215ca6f3ca0%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
