Scenario:
-I'm brand new to SQL Server 2000
-I have a vendor supplied application running on SQLServer 2k.
-I need to log which of my users has seen which data (from a
particular table). It's a healthcare privacy thing.
-The application does not do this and the vendor has no interest in
implementing it, though it seems pretty easy if one has the app code.
So I don't control the application or its code but I need to catch
who's seen what. Note that I don't have to catch it all. In other
words, I don't need to catch every instance, only whether user X has
seen patient Y's data at all. So I'm talking about a fairly small data
set. The end result I'm heading toward is a case in which a patient
demands to know who's seen his health records. I go to a db table and
say "select username from <viewlogtable> where patient_id = XXX".
How do I do that? It'd be easy if I could it were possible to write a
select trigger, or if I had some hooks into the app, but as it is I am
stumped. This is trickier than logging updates and inserts...
Thanks,
John