Re: Generate a CRUD matrix

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:21:33 CST