ansible/ansible — pull request #1376 by stijnopheide (2012-10-18 17:53:03+00:00)
Title: Mysql grant

Suggestion to add GRANT privilege for a user.

usage:
e.g. priv=*.*:ALL,GRANT

the GRANT privilege is not included in ALL, since this is not the case either in the MySQL query. This works well, however, though this is backwards compatible with almost all cases, this change will remove the WITH GRANT OPTION for users that already have it defined in MySQL but do not have it specified in their playbook task.

so, I don't know how you'd like to handle this. Any other options for implementing a fully backwards compatible solution? How do you usually deal with this? You could add an additional module field 'grant' with a default 'as_is' and other options 'enable' 'disable', but the code will look a lot uglier (I tried that first :))