maria-discuss team mailing list archive

[Jimmy Thrasibule <thrasibule.jimmy@xxxxxxxxx>]

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