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