I have recently started migrating some business systems to MariaDB 10.1.13. One of the reasons was to start using the roles functionality to improve management of security and having some consistent viewpoints of it through the use of roles.
One of the things I found not so well pointed out in the document is the fact you need to be fairly fine grained with the grants. For example granting show databases will leave all tables invisible and inaccessible. You will need to grant select on the database to the role to be able to see the tables within that database.
CREATE ROLE DEVELOPER;
GRANT PROCESS, SHOW DATABASES ON *.* TO 'DEVELOPER';
GRANT ROLE DEVELOPER to `pmclarty`;
Log in as user pmclarty
Set ROLE DEVELOPER;
All I can see in MySQL WorkBench a...