[Oracle-l] Auditing clean slate

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

-----Original Message-----
From: andrey khudyakov
Sent: Friday, March 05, 2010 8:24 AM
To: Terrian, Thomas J Mr CTR DLA J6DIB
Cc: oracle-l@freelists.org
Subject: Re: Auditing clean slate

Please, show parameter audit_sys_operations

2010/3/5 Terrian, Thomas J Mr CTR DLA J6DIB

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

-----Original Message-----
From: oracle-l-bounce_at_freelists.org On Behalf Of Terrian, Thomas J Mr CTR DLA J6DIB

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$.

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
--
http://www.freelists.org/webpage/oracle-l

-----Original Message-----
From: oracle-l-bounce_at_freelists.org On Behalf Of Allen, Brandon
Sent: Friday, March 05, 2010 9:47 AM
To: Tom.Terrian.ctr_at_dla.mil; oracle-l_at_freelists.org
Subject: RE: Auditing clean slate

Does the other database also have audit_trail=db?

-----Original Message-----
From: oracle-l-bounce_at_freelists.org On Behalf Of Terrian, Thomas J Mr CTR DLA J6DIB

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$.

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
--
http://www.freelists.org/webpage/oracle-l

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

-----Original Message-----
From: Terrian, Thomas J Mr CTR DLA J6DIB
Sent: Friday, March 05, 2010 8:30 AM
To: andrey khudyakov
Cc: oracle-l@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
Sent: Friday, March 05, 2010 8:24 AM
To: Terrian, Thomas J Mr CTR DLA J6DIB
Cc: oracle-l@freelists.org
Subject: Re: Auditing clean slate

Please, show parameter audit_sys_operations

2010/3/5 Terrian, Thomas J Mr CTR DLA J6DIB

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