Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Obtaining User ID's

Re: Obtaining User ID's

From: Kekko <dini.f_at_adr.it>
Date: Tue, 31 Aug 1999 19:44:23 +0200
Message-ID: <37CC1477.752E110C@adr.it>


This reply is wrong!!!!
Please don't change the subject whe reply!!! Kekko

amerar_at_ci.chi.il.us wrote:

> 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 Tue Aug 31 1999 - 12:44:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US