Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: V$SESSION View
To get the OSUSER of the current user try this statement:
select osuser from v$session where audsid=userenv('SESSIONID');
Arthur Merar a écrit dans le message <37cbb9bc.305082168_at_news.chaven.com>...
>
>Hello,
>
>I am trying to figure out a way to get the OSUSER field from thew
>V$SESSION view.,
>
>Basically I have an ON INSERT trigger that putd data into another
>table when executed. At this time, I want to capture the OSUSER of
>the person who caused the trigger to fire.
>
>How can I single out this record? Can I use the session ID or
>transaction ID or something? How do I get only one record from my
>query? This record being the record of the person who caused the
>trigger to fire........
>
>Thanks,
>
>Please send replies to: amerar_at_ci.chi.il.us
>
>Arthur
>
Received on Tue Aug 31 1999 - 07:29:39 CDT