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

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

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.