Re: USER pseudocolumn

"EdStevens" <quetico_man_at_yahoo.com> a écrit dans le message de news: 1142442445.905578.304150_at_i39g2000cwa.googlegroups.com...
| Oracle 9.2
|
| I've been digging thru tahiti and the ng archives for the last two
| hours, and can't find what I'm looking for.
|
| Trying to set up a logon trigger to start extended tracing ... code is:
|
| create or replace trigger logon_trigger
| after logon on database
| begin
| if (user = 'UC7001' ) then
| execute immediate
| 'ALTER SESSION SET TRACEFILE_IDENTIFIER=''UC7001''';
| execute immediate
| 'ALTER SESSION SET EVENTS ''10046 TRACE NAME CONTEXT FOREVER,
| LEVEL 12''';
| end if;
| end;
|
| Only, instead of referincing the user in the 'if' statement, we want to
| trigger by OS userid. Problem is, I can't find a comprehensive list of
| pseudo columns. Searching tahiti for 'pseudocolumn' obviously yeilds
| several hits, most of which are just passing references. The one place
| that looks like a full list is in the SQL Reference manual, but it only
| lists CURRVAL, NEXTVAL, ROWID, ROWNUM, and XMLDATA. Of course, if I
| search on USER, I get a zillion hits ....
|
| Can someone get me back on track?
|
| Thanks.
|

SYS_CONTEXT('USERENV','OS_USER') Regards
Michel Cadot Received on Wed Mar 15 2006 - 11:22:00 CST