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

thanks for the reply. I did do that but didn't allow other user to alter in workbench. I also tried giving that user elevated privileges for select, update, alter routine, etc. Still nothing.

Is there a specific privilege I need to enable?

I was able to accomplish what I'm wanting by granting that user all *.* but the problem is that they then had visibility and edit ability on all databases. I tried executing grant all only for that database but it didn't change anything.

Options: ReplyQuote


Subject
Written By
Posted
Re: Stored Procedures in Multi User Environment
April 05, 2021 05:58AM


Sorry, only registered users may post in this forum.

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.