All helpful suggestions.

I was missing the following.

set role read_only;

BTW, to find the current role:

select current_role();

Thanks all!

Adam

On Wed, Nov 13, 2013 at 11:21 AM, Federico Razzoli <federico_raz@yahoo.it> wrote:

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:
create role read_only;
grant select on example.* to read_only;
grant usage on example.* to read_only;

grant select on example.* to app_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