Re: Fine-grained auditing question

Howard,

Are you sure you're not confusing
fine-grain-audit with fine-grain-access-control ?

I think audit is specifically, and only, for select statements.

In answer to the OP -
a) what do you mean by a 'failed' select. b) I think to audit inserts, updates and

    deletes you may get something out of     fine-grained-access control, but you might     simply want to look at pre/post DML triggers

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____England______January 21/23


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





Howard J. Rogers wrote in message ...


>Yes, the extra where clause is appended under all circumstances

(barring any


>bugs I might not be aware of). "Update EMP set sal=900 where

ename='BOB'"


>will indeed become "...where ename='BOB' and dept='SALES'"

>

>Regards

>HJR

>