Re: Generate a CRUD matrix

Niall Litchfield wrote:

> 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...
> > 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
> >

I'd correct you if I thought you wrong ... but in this case I think different people have read the request to be asking different things. It appears the OP should repost and clarify.

Or at least let us know who did the best job of guessing the intent.

Daniel Morgan Received on Fri Feb 28 2003 - 11:04:42 CST