Adam, No, I don't think you can do it through DDL. For for regenerating and modifying the code, the simplest to use is DBA_SOURCE.
HTH, SF >----- ------- Original Message ------- ----- >From: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Wed, 03 Dec 2003 19:59:25 > >Folks, > >Is there a way to change the authid setting of a >package via a simple >procedure, e.g., > > alter package x authid current_user; > >I believe this is a compile-time setting, part of >the source of the >package (user_source, dbms_metadata output), which >leads me to believe >there's no simple way to redefine this short of >recreating the package >completely. But let's say we have several hundred >packages to perform >this on -- any easier way to accomplish this? > >Obviously I could use various >dbms_metadata/substr/instr/replace/concatenate >combinations, or Perl, or >any other s//-like mechanism to generate the >updated package text, but I'm >open to other ideas, or perhaps a command/tool I'm >missing. > >Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
