Don't forget about "_system_trig_disabled" ;-) On Thu, Jun 26, 2008 at 8:29 PM, Lyndon Tiu <ltiu@xxxxxxxxxxxxx> wrote: > We use: > > 1) sys.aud$ > > 2) Each table has a last_updated_date and a last_updated_by column. It gets > updated by a trigger: > > CREATE OR REPLACE TRIGGER TABLE.LAST_UPDATE_TRG > before insert or update on > TABLE > for each row > begin > :new.last_updated_date := sysdate; > :new.last_updated_by := sys_context('USERENV','OS_USER') || ' ' || > sys_context('USERENV','HOST') || ' ' || sys_context('USERENV','IP_ADDRESS'); > end; > / > > > On Thu, 26 Jun 2008 13:11:56 -0500 litanli@xxxxxxxxx wrote: > > Hi, List, > > > > Can you please share the best practice inside your organization about > > how you meet your audit requirement? How do you audit oracle users, > > especially DBAs? > > -- > Lyndon Tiu > -- > //www.freelists.org/webpage/oracle-l > > > -- ========================= Stefan P Knecht Senior Consultant Infrastructure Managed Services Trivadis AG Europa-Strasse 5 CH-8152 Glattbrugg Phone +41-44-808 70 20 Fax +41-808 70 12 Mobile +41-79-571 36 27 stefan.knecht@xxxxxxxxxxxx http://www.trivadis.com OCP 9i/10g SCSA SCNA =========================