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; > > Here, the role takes a parameter we can use to make privileges a bit > more dynamic. We can 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