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