RE: Programmatically redefining authid setting on packages

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: AdamDonahue_at_maximus.com
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>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: sfaroult_at_oriolecorp.com

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: ListGuru_at_fatcity.com (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).