Auditing clean slate
From: Terrian, Thomas J Mr CTR DLA J6DIB <Tom.Terrian.ctr_at_dla.mil>
Date: Fri, 5 Mar 2010 07:41:37 -0500
Message-ID: <B538F62DA0448741B308EA69417CC30206A7B533_at_COL1SMX19.USE.AD.DLA.MIL>
Version 10.2
Date: Fri, 5 Mar 2010 07:41:37 -0500
Message-ID: <B538F62DA0448741B308EA69417CC30206A7B533_at_COL1SMX19.USE.AD.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||';' fromdba_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-lReceived on Fri Mar 05 2010 - 06:41:37 CST