logging changes to objects in database

  • Thread starter Thread starter Craig
  • Start date Start date
C

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
 
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
 
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
 
Back
Top