Re: Database auditing

The attached script will create a view DBA_TABLE_AUDIT_FLAGS.

If you create this, do it as SYS or SYSDBA.

The following statement will show tables are being audited:

  select * from dba_table_audit_flags;

Jared

On 8/10/06, Fred Smith <fred_fred_1_at_hotmail.com> wrote:
>
> How can I check if the previous dba left anything auditing in my database?
>
> Thanks!
>
> _________________________________________________________________
> FREE pop-up blocking with the new MSN Toolbar – get it now!
> http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist




--
http://www.freelists.org/webpage/oracle-l




text/x-sql attachment: dba_table_audit_flags.sql