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 -> Obtaining User ID's

Obtaining User ID's

From: <amerar_at_ci.chi.il.us>
Date: Mon, 30 Aug 1999 15:54:50 GMT
Message-ID: <7qe9g4$s7h$1@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 - 10:54:50 CDT












Original text of this message













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