maria-discuss team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

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