RE: Auditing clean slate
- From: FMHabash <fmhabash@xxxxxxxxx>
- To: <Tom.Terrian.ctr@xxxxxxx>, andrey khudyakov <andrey.hudyakov@xxxxxxxxx>
- Date: Fri, 5 Mar 2010 09:48:21 -0500
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@xxxxxxx>
Sent: Friday, March 05, 2010 8:30 AM
To: andrey khudyakov <andrey.hudyakov@xxxxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx]
Sent: Friday, March 05, 2010 8:24 AM
To: Terrian, Thomas J Mr CTR DLA J6DIB
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Auditing clean slate
Please, show parameter audit_sys_operations
2010/3/5 Terrian, Thomas J Mr CTR DLA J6DIB <Tom.Terrian.ctr@xxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
