Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Generate a CRUD matrix
Correct me if I'm wrong but running a sql trace on the session and then
TKPROF'ing it will give all the tables accessed during the session as
originally requested. This is not the same as auditing, but it doesn't
appear to be auditing that he is after.
-- Niall Litchfield Oracle DBA Audit Commission UK "DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E5F8C8D.5ADEDF1_at_exesolutions.com...Received on Fri Feb 28 2003 - 10:53:59 CST
> David FitzGerald wrote:
>
> > DA Morgan <damorgan_at_exesolutions.com> wrote in message
> >
> > > You can audit insert, update, and delete (triggers and audit). But
> > > select? You really don't want to go there.
> >
> > I think you misunderstand slightly... I don't want to see every
> > select, insert, undate or delte -- all I want to know is if that table
> > was accessed whatsoever during a given session.
> >
> > <snipped>
> >
> >
> > Many thanks,
> >
> > David.
>
> Same answer. There is no way to audit SELECTs other than by brute force
> looking at open cursors, etc. And then there's dynamic SQL with bind
> variables.
>
> Daniel Morgan
>