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: Barbara Baker <barb.baker_at_gmail.com>
Date: Thu, 10 Aug 2006 09:19:43 -0600
Message-ID: <47a6f72b0608100819j9170e54rc631f80cdec4b344@mail.gmail.com>


prompt ** &&v_dbname Statement current audit options enabled ** select * from sys.dba_stmt_audit_opts;

prompt ** &&v_dbname Privilege current audit options enabled ** select * from sys.dba_priv_audit_opts;

prompt ** &&v_dbname Current audit options enabled for objects **

select owner, object_name, object_type,

       alt,aud,com,del,gra,ind,ins,loc,ren,sel,upd,ref,exe from sys.dba_obj_audit_opts
where

   alt !='-/-' or aud !='-/-' or com !='-/-'
or del !='-/-' or gra !='-/-' or ind !='-/-'
or ins !='-/-' or loc !='-/-' or ren !='-/-'
or sel !='-/-' or upd !='-/-' or ref !='-/-' or exe !='-/-'
/

hth!
Barb

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
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 10 2006 - 10:19:43 CDT

Original text of this message

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