Stored Procedures in Multi User Environment
Posted by: Steve Young
Date: April 03, 2021 08:35PM

I'm trying to better understand definers and how to allow multiple developers to interact with them. Specifically if I create a stored procedure then my coworker in unable to alter it in the workbench. Similarly, if he creates a sp then I can't alter it or execute unless I type call xxx.

I understand this has to do with the definer but how do large companies accomplish this? It's unrealistic to expect that I'll be the only one to manage my sp's or him manage his. We have to be able to quickly access them in workbench make any needed edits and save them.

Is there a setting I'm missing? How can we have multiple people interact with an sp in workbench. Currently we both have full privilege's to the database. Is there another permission somewhere?

Options: ReplyQuote


Subject
Written By
Posted
Stored Procedures in Multi User Environment
April 03, 2021 08:35PM


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.