Re: How do you meet your audit requirement?
Date: Fri, 27 Jun 2008 09:43:21 +0200
Message-ID: <486b2b610806270043o336fe8aeo590dbf5aa4e6ffa5@mail.gmail.com>
Don't forget about "_system_trig_disabled" ;-)
On Thu, Jun 26, 2008 at 8:29 PM, Lyndon Tiu <ltiu_at_alumni.sfu.ca> 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_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-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_at_trivadis.com http://www.trivadis.com OCP 9i/10g SCSA SCNA ========================= -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 27 2008 - 02:43:21 CDT