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 wrote:
> Did you run SET ROLE? Roles are not activated automatically. Users must
> declare the
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 ha
scritto:
Roles are supported according to
(https://blog.mariadb.org/mariadb-10-0-beta-launched-an-important-mile
flush privileges after last grant ?
2013/11/13 Adam Scott
> 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
Hi, Adam!
On Nov 13, Adam Scott wrote:
> 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_onl
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'
5 matches
Mail list logo
