Re: Obtaining User ID's

To get the OSUSER of the current user try this statement:

select osuser from v$session where audsid=userenv('SESSIONID');

amerar_at_ci.chi.il.us a écrit dans le message <7qe9g4$s7h$1_at_nnrp1.deja.com>...
>
>
>Hello,
>
>I have a trigger that inserts records into an internal audit trail when
>a user inserts records into another table. Now, I need to add the user
>ID field. This User ID is the OSUSER from v$session. But, how do I
>single out the transaction that is doing the insert so I can use the
>session ID to get the OSUSER?
>
>Can anyone help please?
>
>Thanks,
>
>Arthur
>amerar_at_ci.chi.il.us
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Mon Aug 30 1999 - 13:26:41 CDT