Re: Auditing clean slate

From: andrey khudyakov <andrey.hudyakov_at_gmail.com>
Date: Fri, 5 Mar 2010 15:23:32 +0200
Message-ID: <ef6564031003050523i40453000v28239f1a98f76beb_at_mail.gmail.com>

Please, show parameter audit_sys_operations

2010/3/5 Terrian, Thomas J Mr CTR DLA J6DIB <Tom.Terrian.ctr_at_dla.mil>

> Version 10.2
>
> I am trying to clean up our sys.aud$ table. I want to clean slate our
> auditing and start over. I don't want to disable auditing with the
> audit_trail parameter. I just want to noaudit everything and then
> selectively turn auditing back on for a few operations. I thought the
> following would noaudit everything but I am still getting lots of records
> added to sys.aud$:
>
> select 'noaudit '||audit_option||';' from dba_stmt_audit_opts;
> select 'noaudit '||privilege||';' from dba_priv_audit_opts;
> select 'noaudit all on '||OWNER||'.'||object_name||';' from
> dba_obj_audit_opts where object_type in('TABLE','VIEW');
>
> Does anyone have a script to clean slate their auditing?
>
> Thanks,
> Tom Terrian
>
>

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

Received on Fri Mar 05 2010 - 07:23:32 CST