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