logging changes to objects in database

[Craig]

I was wondering if there was a way to log which users
opens, executes, or makes changes to a particular query.
I have a module which logs which users are entering the
database and is kept track in a table. I was wondering if
there is a way to do this but for a particular query. I
would like to capture their network login name as well as
the time and date.

Thanks for any help!

Craig

 

[TC]

When you say "makes changes to a particular query", do you mean (a) changes
the design of the query, or (b) changes the data displayed by the query?

TC

 

[craig]

I am looking to audit who is modifying the query itself,
not the output.

 

[TC]

No can do (AFAIK) - unless you fake it by requiring all users to enter their
query modifications *via a form*. Then that form could audit the change &
amend the query SQL. Would that do?

HTH,
TC