[Maria-discuss] Maria DB 10.0 Roles Usage
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
flush privileges after last grant ? 2013/11/13 Adam Scott <adam.c.scott@gmail.com>
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
-- Roberto Spadim SPAEmpresarial
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_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.
Please verify that you're really logged as app_report@localhost. Try SELECT CURRENT_USER(); And SHOW GRANTS; Regards, Sergei
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
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
participants (4)
-
Adam Scott -
Federico Razzoli -
Roberto Spadim -
Sergei Golubchik