maria-discuss team mailing list archive
Mailing list archive
Re: Role template
If statements like CREATE ROLE were allowed in prepared statements, this could easily be done with a stored procedure.
El jue, 22/5/14, Sergei Golubchik <serg@xxxxxxxxxxx> escribió:
Asunto: Re: [Maria-discuss] Role template
Para: "Jimmy Thrasibule" <thrasibule.jimmy@xxxxxxxxx>
Fecha: jueves, 22 de mayo, 2014 18:52
On May 18, Jimmy Thrasibule
> Roles have been introduced with MariaDB
10.0.5. This feature is
interesting to group and standardize grants in one place.
> 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
> 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
> GRANT r1(mydb) TO
> 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
request on mariadb.org/jira - but don't hold your
might take a while to get it
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp