Re: Stored Procedures in Multi User Environment
Posted by: Steve Young
Date: April 05, 2021 07:35AM

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.

Options: ReplyQuote

Written By
Re: Stored Procedures in Multi User Environment
April 05, 2021 07:35AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.