RE: Simple auditing question

From: CRISLER, JON A (ATTCORP) <"CRISLER,>
Date: Wed, 8 Dec 2010 19:33:56 -0500
Message-ID: <B8CFC366C968D84FB8241B6E6B0EA19A04E44386_at_misout7msgusr82.ITServices.sbc.com>

The Oracle Security manuals for 10g and 11g do a good job of explaining DB auditing.  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Subodh Deshpande Sent: Tuesday, December 07, 2010 6:14 AM To: oracledba.williams_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: Simple auditing question  

Dennis,  

There are various types of audit, database level, schema level and table level.

Audit should be used carefully, it is some sort of extra load on database.

what do you want to audit who fires which statement(this is for database security..you can use audit) or who changes what data or when and which business event changes the data (business cycle monitoring..you should design your application for this)

thanks!

Subodh

On 4 December 2010 01:14, Dennis Williams <oracledba.williams_at_gmail.com> wrote:

List,  

I haven't used Oracle Auditing much, so this is probably a newbie question. Need to turn on auditing for a high-volume OLTP database. My understanding is that if I turn on AUDIT TABLE, it gets everything. I don't need to know all the inserts, updates on these tables. Is there a simpler audit setting? I probably am missing a concept.  

Thanks,

Dennis Williams

-- 


==============================

DO NOT FORGET TO SMILE TODAY


==============================



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

Received on Wed Dec 08 2010 - 18:33:56 CST