maria-discuss team mailing list archive

[Adam Scott <adam.c.scott@xxxxxxxxx>]

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@xxxxxxxx>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@xxxxxxxxx>
> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help  : https://help.launchpad.net/ListHelp
>
>
>