V$SESSION View

From: Arthur Merar <amerar_at_unsu.com>
Date: Tue, 31 Aug 1999 11:19:52 GMT
Message-ID: <37cbb9bc.305082168@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 - 06:19:52 CDT