If statements like CREATE ROLE were allowed in prepared statements, this could easily be done with a stored procedure. Regards Federico -------------------------------------------- El jue, 22/5/14, Sergei Golubchik <serg@mariadb.org> escribió: Asunto: Re: [Maria-discuss] Role template Para: "Jimmy Thrasibule" <thrasibule.jimmy@gmail.com> CC: maria-discuss@lists.launchpad.net Fecha: jueves, 22 de mayo, 2014 18:52 Hi, Jimmy! On May 18, Jimmy Thrasibule wrote:
Hi,
Roles have been introduced with MariaDB 10.0.5. This feature is very interesting to group and standardize grants in one place. However roles are static, meaning that it is not possible to create a template
to apply later on another database.
I'm looking for something similar to a
stored procedure:
CREATE ROLE r1(db); GRANT ALL PRIVILEGES ON
$(db).* TO r1;
more dynamic. We can
Here, the role takes a parameter we can use to make privileges a bit then apply this role on a dedicated database
like:
GRANT r1(mydb) TO 'myuser'@'localhost';
Can this already be done or do you
think that's a feature that could come? no, I don't think this can be done with roles. that's certainly a feature that could come - particularly if you create a feature request on mariadb.org/jira - but don't hold your breath, it might take a while to get it implemented. Regards, Sergei _______________________________________________ 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