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 -> Audit with triggers

Audit with triggers

From: Frederic DEBRUS <frederic.debrus_at_ces-cdr.be>
Date: 20 Sep 1999 14:41:01 GMT
Message-ID: <01bf0377$384b1720$3e35a99e@gal159a>


Hi there,

        I'm trying to make some audit using triggers, populating a "manipulation table" recording who made what with the values of the column before and after it's working fine but I would like
to kwown the osuser and record it. How can I access this information from my trigger (select osuser from sys.v_$session where ?????)

thanks Received on Mon Sep 20 1999 - 09:41:01 CDT

Original text of this message

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