Did you run SET ROLE? Roles are not activated automatically. Users must declare they want to use a particular role. Federico Il Mercoledì 13 Novembre 2013 18:37, Adam Scott <adam.c.scott@gmail.com> ha scritto: Roles are supported according to (https://blog.mariadb.org/mariadb-10-0-beta-launched-an-important-milestone/) So the following commands worked: createroleread_only; grantselectonexample.*toread_only; grantusageonexample.*toread_only; grantselectonexample.*toapp_report@'localhost'; When i logged in as app_report, show databases did not show the example database. And selects against tables in the example database did not work. What am I missing? Thanks, Adam C. Scott _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp