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

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