18 May
2014
18 May
'14
7:13 p.m.
Hi, Roles [1] 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? [1]: https://mariadb.com/kb/en/roles-overview/ Regards, Jimmy