Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Generate a CRUD matrix

Re: Generate a CRUD matrix

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 28 Feb 2003 16:53:59 -0000
Message-ID: <3e5f9427$0$6302$ed9e5944@reading.news.pipex.net>


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
>
Received on Fri Feb 28 2003 - 10:53:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US