"priv" not considered

[michel-thomas]

Hello,

I tried this

mysql_users:
  - name:             "user1"
    password:         "{{ mariadb_nextcloud_password }}"
    priv:             'mybase.*:USAGE'

but my user always have full databases access:

MariaDB [mysql]> SHOW GRANTS for 'user1'@'localhost';
+---------------------------------------------------------------------------------------------------------------+
| Grants for user1@localhost                                                                                   |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO `user1`@`localhost` IDENTIFIED BY PASSWORD '*9F85B86C3C4A9AAF680D3D30CDD8596B52E1ABE0' |
+---------------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)

I tried to set append_privs: yes but the same. Is there a bug or something I do wrong?

FIY: my tests are with only one base and only one user to create/update.

Role version is 3.3.0, host is Debian 10 up to date.

Thanks for your help.

[stale[bot]]

This issue has been marked 'stale' due to lack of recent activity. If there is no further activity, the issue will be closed in another 30 days. Thank you for your contribution!

Please read this blog post to see the reasons why I mark issues as stale.

[stale[bot]]

This issue has been closed due to inactivity. If you feel this is in error, please reopen the issue or file a new issue with the relevant details.