Re: USER pseudocolumn
- From: "Michel Cadot" <micadot{at}altern{dot}org>
- Date: Wed, 15 Mar 2006 18:22:00 +0100
"EdStevens" <quetico_man@xxxxxxxxx> a écrit dans le message de news: 1142442445.905578.304150@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
| 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
.
- References:
- USER pseudocolumn
- From: EdStevens
- USER pseudocolumn
- Prev by Date: Re: Log user account lockouts
- Next by Date: Re: how does Oracle do field comparisons with good performance ?
- Previous by thread: USER pseudocolumn
- Next by thread: Please help! Oracle 10g repository creation quesiton
- Index(es):
Relevant Pages
|
