Re: Stored Procedures in Multi User Environment

[Steve Young]

To further add on to my reply. I'm using the following statement to elevate privleges for this user. However, when I go to workbench I still can't alter a stored procedure.

GRANT ALL PRIVLEGES ON dev1.* TO 'username'@'%';

If I apply privilege's for *.* instead of a specific db then all works fine but since the scope is now global the user can see/alter other databases.

What is the additional privlege when applying to global that isn't applied at a db level that allows routines to be altered in workbench? It seems that if I grant all at a db level it should allow it.