Re: I hate auditing!!!

Hi,

This is the process at least for Oracle 8i, might be helpful to you.

After enabling the audit in init.ora (audit_trail = DB/TRUE/OS) you need to execute the sql script cataudit.sql. After that define the users,actions and objects you want to audit( audit create any table by access;audit drop any table by access; etc)

Regards

Umesh
extents_at_gmail.com wrote:
> Hi
> I think I have far too much documentation to this simple audit and
> still isnt working....Im doing a simple test. Version 9.2.0 .
> audit_trail = DB . Restarted the instance.
>
> Ran as sysdba
> audit create any table by access;
> audit drop any table by access;
>
> As scott (a user)
> create table t3 (a number);
> drop table t3;
>
> Shuldnt there be an entry in aud$ for dropping the table t3? All I want
> to do is audit drop commands. How do I do it?
>
> Thanks in advance
Received on Mon Sep 12 2005 - 05:51:50 CDT