Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Database auditing

Re: Database auditing

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 22 Aug 2006 10:55:02 -0700
Message-ID: <bf46380608221055g2d0838ebuaa6e271850c59e1@mail.gmail.com>


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

Received on Tue Aug 22 2006 - 12:55:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US