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 <[email protected]> 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 : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
