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