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

I may not be understanding correctly but I currently have about 15 stored procedures. All of them reference and use a single database. Currently if I login to workbench and connect to the database as a regular user I can't alter any stored procedures.

Only if I grant all privleges (*.*) then I can but that allows me to see all other db's as well.

I've got to be missing something obvious because having a multiuser environment can't be this difficult

Options: ReplyQuote


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


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.