|Subject:||Fine-grained auditing question|
|Date:||16 Dec 2002|
I'm thinking about playing around with this and I have a few
questions. All of the documentation I've read talks and shows how to
use it for watching "selects",
object_schema => 'hr',
object_name => 'emp',
policy_name => 'chk_hr_emp',
audit_condition => 'dept = ''SALES'' ',
audit_column => 'salary');
SELECT salary FROM hr.emp WHERE dept = 'SALES';
If I do an update on this column, will the preceeding policy trigger
an audit event? If not, can someone show me the code to do so?
Lastly, is it possible to use fine-grained auditing to track only
unsuccessful selects/updates/etc? If so, how?
Thanks in advance.