RE: Simple auditing question

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: