You could use Logminer supplemental logging to get any update information.
Lots of overhead but doable.
HTH
tED
"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
news:N7rL9.4444$jM5.12785_at_newsfeeds.bigpond.com...
> 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 - 18:59:28 CST
