RE: Simple auditing question
- From: "CRISLER, JON A (ATTCORP)" <JC1706@xxxxxxx>
- To: <deshpande.subodh@xxxxxxxxx>, <oracledba.williams@xxxxxxxxx>
- Date: Wed, 8 Dec 2010 19:33:56 -0500
The Oracle Security manuals for 10g and 11g do a good job of explaining
DB auditing.
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Subodh Deshpande
Sent: Tuesday, December 07, 2010 6:14 AM
To: oracledba.williams@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx>
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
==============================
Other related posts:
