RE: Auditing clean slate

From: FMHabash <fmhabash_at_gmail.com>
Date: Fri, 5 Mar 2010 09:48:21 -0500
Message-ID: <4b9119b6.9753f10a.64b3.4b66_at_mx.google.com>

This should turn all audit opts off

Noaudit all;
Noaudit all privileges ;
Noaudit all on default ;

You can NOT turn basic sys audits off by design.

-----Original Message-----

From: Terrian, Thomas J Mr CTR DLA J6DIB <Tom.Terrian.ctr_at_dla.mil> Sent: Friday, March 05, 2010 8:30 AM
To: andrey khudyakov <andrey.hudyakov_at_gmail.com> Cc: oracle-l_at_freelists.org
Subject: RE: Auditing clean slate

SQL> sho parameter audit_sys_operations;

NAME                                 TYPE        VALUE


------------------------------------ -----------

------------------------------

audit_sys_operations                 boolean     TRUE

I don't think this is the problem since the database next to it also has audit_sys_operations = True but generates no records in sys.aud$.

-----Original Message-----

From: andrey khudyakov [mailto:andrey.hudyakov_at_gmail.com] Sent: Friday, March 05, 2010 8:24 AM
To: Terrian, Thomas J Mr CTR DLA J6DIB
Cc: oracle-l_at_freelists.org
Subject: Re: Auditing clean slate

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 - 08:48:21 CST