Re: How do you meet your audit requirement?
From: Lyndon Tiu <ltiu_at_alumni.sfu.ca>
Date: Thu, 26 Jun 2008 11:29:40 -0700
Message-Id: <200806261829.m5QITelT004856@rm-rstar.sfu.ca>
Date: Thu, 26 Jun 2008 11:29:40 -0700
Message-Id: <200806261829.m5QITelT004856@rm-rstar.sfu.ca>
We use:
- sys.aud$
- 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_at_gmail.com 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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 26 2008 - 13:29:40 CDT