To allow some basic permissions to all of our groups in memSQL I want to create a new ‘base’ role and grant it to all groups.
I tried to use stored procedure to do that and iterate over information_schema but ‘grant role’ is not allowed inside stored procedure
Are there any suggestions for such batch grant?
Quick solution that comes to my mind is that you can fetch result from information_schema in your application and then loop over it in your application, granting role to each group.
MemSQL 7.0 will allow to call grant role from store procedures.