Re: Fine-grained auditing question

Ooops.

I certainly was confusing the two, and that was just 6.00am wooziness. My apologies.

FG auditing most definitely is only for selects.

Regards
HJR "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:atlel0$a11$1$8302bc10_at_news.demon.co.uk...
>
> 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
> >
>
>
>
Received on Mon Dec 16 2002 - 15:08:09 CST