RE: Simple auditing question
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <oracledba.williams@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 3 Dec 2010 14:52:13 -0500
Dennis,
Yeah you need to do a through read on the audit statement in the sql
language manual. Depending on what you really need the following is
probably a good example:
AUDIT SELECT
ON hr.employees
WHENEVER SUCCESSFUL;
Again it depends on what your needs are.
Dick Goulet
Senior Oracle DBA
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dennis Williams
Sent: Friday, December 03, 2010 2:44 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Simple auditing question
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
Other related posts:
