USER pseudocolumn

From: EdStevens <quetico_man_at_yahoo.com>
Date: 15 Mar 2006 09:07:25 -0800
Message-ID: <1142442445.905578.304150@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. Received on Wed Mar 15 2006 - 11:07:25 CST