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 -> find out who makes the update in a trigger event

find out who makes the update in a trigger event

From: steno <snovotny_at_integro.net>
Date: Thu, 17 May 2001 11:35:31 +0200
Message-ID: <9e0619$bhnt$1@ID-37725.news.dfncis.de> 






 hi there,



 i want to log database changes trough triggers.
 therefore i need to know which session fires the trigger. is there a
 possibilty to get the SID from the session which fired the trigger?



 additionally i added triggers on v$session to recognize if there is a new
 session


 and capture the commit and rollback command.



 thanks in advance


 steno
Received on Thu May 17 2001 - 04:35:31 CDT












Original text of this message













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