Re: Auditing the Oracle server

From: Randy Reiter <rreiter_at_sqlpower.com>
Date: Sun, 4 Apr 1999 08:07:40 -0400
Message-ID: <7e7kto$igs$1@bgtnsc02.worldnet.att.net>

Refer to www.sqlpower.com.

These ZERO impact SQL transaction level capture, audit, monitoring, performance and service level statistics products will be available for Oracle SOON!

Randy Reiter

Sql Power Tools
www.sqlpower.com
201.825.9511

johnkoo wrote in message <7e78g9$eca4_at_news.hk.linkage.net>...
>Hi all,
>
> I am sure many of you guys know the built-in AUDIT TRAIL option of
Oracle
>server and all the audit records are stored in SYS.AUD$. Right ? The Oracle
>document suggested that one's better audited the SYS.AUD$ against some
third
>party's updating and deleting it. But the problem is : How can you guard
>against someone TRUNCATING the SYS.AUD$??? I've tried it on my experimental
>server and found that when you TRUNCATE the SYS.AUD$, there was no audit
>record left behind. But is there any method to keep any log when
someone(not
>you) truncate the SYS.AUD$ table ??
>
>John K.
>johnkoo_at_i-wave.net
>
>
>
Received on Sun Apr 04 1999 - 07:07:40 CDT