Re: How to get UID of executing user ina trigger?

UID gives the current executing user, see:

SQL> create or replace trigger tt after insert on t   2 declare
  3 currentid number;
  4 ownerid number;
  5 begin
  6 dbms_output.enable;
  7 select userenv('SCHEMAID'), uid into ownerid, currentid from dual;   8 dbms_output.put_line('current id is '||currentid||' - owner id is '||ownerid);
  9 end;
 10 /

Trigger created.

SQL>set serveroutput on
SQL>insert into t values(0);
current id is 79 - owner id is 79

1 row created.

SQL>select user, uid from dual;

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

1 row selected.

SQL>connect system_at_refold
Enter password:
Connected.
SQL>select user, uid from dual;

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

1 row selected.

SQL>set serveroutput on
SQL>insert into MMA$EP34087.t values (1); current id is 5 - owner id is 79

1 row created.

Peter Laursen a écrit dans le message <01bf0055$e2b0a1f0$2c289a0a_at_apollo>...
>If I do :new.user_id = UID
>in a trigger, I get the UID of the owner/creater of the trigger.
>How do I get the UID of the user thats does the DML that makes the trigger
>execute?
>
>Thanks
>Peter Laursen
Received on Thu Sep 16 1999 - 09:47:57 CDT