Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL procedure or package owner ?

Re: PL/SQL procedure or package owner ?

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Mon, 17 Jan 2000 10:33:43 +0100
Message-ID: <85unlo$1brs$1@news6.isdnet.net>


You can use the userenv function and the all_users view to dynamicaly know the owner of a procedure:

v734>create or replace procedure p is
  2 ownername all_users.username%type;   3 begin
  4 dbms_output.enable;
  5 select username into ownername from all_users where user_id=userenv('SCHEMAID');
  6 dbms_output.put_line('owner is '||ownername);   7 end;
  8 /

Procedure created.

v734> select user, uid from dual;

USER                                  UID
------------------------------ ----------
MMA$EP34087                            79

v734> set serveroutput on
v734> exec p;
owner is MMA$EP34087

PL/SQL procedure successfully completed.

v734> @connect system_at_refold
Enter password: ********
Connected.

v734> select user, uid from dual;

USER                                  UID
------------------------------ ----------
SYSTEM                                  5

v734> set serveroutput on
v734>exec mma$ep34087.p;
owner is MMA$EP34087

PL/SQL procedure successfully completed.

--
Have a nice day
Michel

Igor V. Podolsky <igoryok_at_soft-review.kiev.ua> a Êcrit dans le message : AAZqRVuy900_at_soft-review.kiev.ua...
> Hi !
>
> Is there a way to determine a package (or procedure) owner from the package
> ?
> I need to write procedure that works by following way: it should always
> return it owner (it scheme name by other words).
> There is a built-in 'user' procedure but it returns name of user that called
> it, not owner name.
> Any suggestions ?
>
> P.S. Duplicate answers to igoryok_at_soft-review.kiev.ua please.
>
> --
> Is There A God Or Any Kind Of Justice Under The Sky... (Queen'91)
>
> Igor V. Podolsky (igoryok_at_soft-review.kiev.ua)
>
Received on Mon Jan 17 2000 - 03:33:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US