Our database account/permissions generation has a lot of issues as noted in T140832. This is mostly user facing / user impacting. One issue that primarily administrative is the madness of thousands of user accounts with individual grants. These are difficult to audit, reason about, investigate, and ensure consistency.

Beginning with mariadb 10.0.5 we can possibly use the roles idiom https://mariadb.com/kb/en/mariadb/roles-overview/ to create a consistent grant for all users. This seems made for our many users with the same permissions use case.