Re: Database auditing

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