diff options
| author | Andrew Klychkov <aaklychkov@mail.ru> | 2021-02-05 23:47:09 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-02-05 14:47:09 -0600 |
| commit | 2282325334c565925f113cd77f74654ad12339d3 (patch) | |
| tree | b3d8fad36a41fb407b88e93fcccd140c1e7b9112 | |
| parent | 98973468dab7a19c12499297d6f0143e9e4ee0f1 (diff) | |
| download | ansible-2282325334c565925f113cd77f74654ad12339d3.tar.gz | |
mysql_user: Add missed privileges support (#73271)
Co-authored-by: Andrew Klychkov <andrew.klychkov@gmail.com>
| -rw-r--r-- | changelogs/fragments/87-mysql_user_update_valid_privs_frozen_set.yml | 4 | ||||
| -rw-r--r-- | lib/ansible/modules/database/mysql/mysql_user.py | 14 |
2 files changed, 17 insertions, 1 deletions
diff --git a/changelogs/fragments/87-mysql_user_update_valid_privs_frozen_set.yml b/changelogs/fragments/87-mysql_user_update_valid_privs_frozen_set.yml new file mode 100644 index 0000000000..e4813f3e4d --- /dev/null +++ b/changelogs/fragments/87-mysql_user_update_valid_privs_frozen_set.yml @@ -0,0 +1,4 @@ +bugfixes: +- mysql_user - add ``SHOW_ROUTINE`` privilege support (https://github.com/ansible-collections/community.mysql/issues/86). +- mysql_user - add missed privileges to support (https://github.com/ansible-collections/community.general/issues/617). +- mysql_user - add ``INVOKE LAMBDA`` privilege support (https://github.com/ansible-collections/community.general/issues/283). diff --git a/lib/ansible/modules/database/mysql/mysql_user.py b/lib/ansible/modules/database/mysql/mysql_user.py index de5bd7edc7..e370cbdfda 100644 --- a/lib/ansible/modules/database/mysql/mysql_user.py +++ b/lib/ansible/modules/database/mysql/mysql_user.py @@ -237,7 +237,19 @@ VALID_PRIVS = frozenset(('CREATE', 'DROP', 'GRANT', 'GRANT OPTION', 'GROUP_REPLICATION_ADMIN', 'PERSIST_RO_VARIABLES_ADMIN', 'REPLICATION_SLAVE_ADMIN', 'RESOURCE_GROUP_ADMIN', 'RESOURCE_GROUP_USER', 'ROLE_ADMIN', 'SESSION_VARIABLES_ADMIN', 'SET_USER_ID', - 'SYSTEM_VARIABLES_ADMIN', 'VERSION_TOKEN_ADMIN', 'XA_RECOVER_ADMIN')) + 'SYSTEM_VARIABLES_ADMIN', 'VERSION_TOKEN_ADMIN', 'XA_RECOVER_ADMIN', + 'INVOKE LAMBDA', + 'ALTER ROUTINE', + 'BINLOG ADMIN', + 'BINLOG MONITOR', + 'BINLOG REPLAY', + 'CONNECTION ADMIN', + 'READ_ONLY ADMIN', + 'REPLICATION MASTER ADMIN', + 'REPLICATION SLAVE', + 'REPLICATION SLAVE ADMIN', + 'SET USER', + 'SHOW_ROUTINE',)) class InvalidPrivsError(Exception): |