Copyright © 2016 MariaDB. All rights reserved.
Get the Free Gartner Report on Optimizing with Open Source
How do I get a user's default role?
Good question. only by querying mysql.user table, so it seems. Looks like a serious omission. Could you create an issue in Jira for it and we'll fix it? And feel free to suggest there how and where one should be able to see user's default role.
Have added to JIRA: https://mariadb.atlassian.net/browse/MDEV-6918
Download MariaDB and start working immediately! You can also get subscription details and learn more about the advantages of MariaDB's additional service offers.