maria-discuss team mailing list archive

[Federico Razzoli <federico_raz@xxxxxxxx>]

If statements like CREATE ROLE were allowed in prepared statements, this could easily be done with a stored procedure.

Regards
Federico


--------------------------------------------
El jue, 22/5/14, Sergei Golubchik <serg@xxxxxxxxxxx> escribió:

 Asunto: Re: [Maria-discuss] Role template
 Para: "Jimmy Thrasibule" <thrasibule.jimmy@xxxxxxxxx>
 CC: maria-discuss@xxxxxxxxxxxxxxxxxxx
 Fecha: jueves, 22 de mayo, 2014 18:52
 
 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
 
 _______________________________________________
 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