RE: Implementing Stored Procedures

<FONT face="Courier New" color=#0000ff

size=2>One option (and I'm not suggesting that this is the BEST option by any means, but it IS an option =) might be to grant the developer(s) the 'CREATE ANY PROCEDURE' role, and then have them create their procedures/functions/packages etc as <schema_name>.<object_name>, with <schema_name> being the name of the application schema that the object will need to be in.
<FONT face="Courier New" color=#0000ff

size=2> 
<FONT face="Courier New" color=#0000ff

size=2>-::YEX::-
<FONT face="Courier New" color=#0000ff

size=2><)))><

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Yttri, Lisa   [mailto:lisa.yttri_at_cnh.com]Sent: Thursday, 31 May, 2001 13:02   PMTo: Multiple recipients of list ORACLE-LSubject:   Implementing Stored Procedures
  Hi -
  I'd like some advice on implementing stored procedures   containing application logic (ie. written by developers).  We have   several applications where the developers use stored procedures for much of   their coding.  We let the developers create or replace their procedures   in a development environment under their own schema (with access to all   application tables, etc.) to test the logic, but it currently requires a DBA   to implement the proc under the application schema.   It has gotten   to be a very time-consuming job.  We don't want to give out the schema   owner password to the developers, nor do we know of a way they could add them   as the schema owner without giving them more privileges than we   want.
  I am curious of how others are handling stored procedure   additions and modifications.    Do you somehow allow developers   this access?  If so, how do you restrict them from damaging other   things?  If not, does the DBA do it?   Does anyone have an   automated way?   Also, do you keep track of the original "source   code" for the procedure, or do you extract it out of the database as   needed?
  Thanks so much for your input - <FONT   size=2>Lisa Received on Thu May 31 2001 - 15:25:18 CDT