Table View Record

[cpaige]

Hi,
Is there some way I can write code that will execute everytime a table is read?
Thanks,

Clayton T. Paige
claytonpaige@yahoo.ca

Programmer Extraordinaire

========================================================

"Who is General Failure? and Why is he reading my disk drive?"

 

[vadimg]

Here's a very clumsy solution, i hope someone comes up with something better. I had to do this in a development system to catch people browsing user-info tables... Would definitely avoid this solution anywhere but development machines.

Start profiler with output going to a table, filtering on TextData, ExecutionPlan, or anything else that would tell you that the table is being read.

Create a trigger on the profiler output table with your code.

 

[billchris]

Another option depends on the permissions of your users. If they don't have sysadmin or db_owner permissions, you can DENY SELECT permission on the table and then write a stored procedure to do selecting on that table. You can log whatever you want in the stored procedure.


“I apologize for this long letter. I didn't have the time to make it any shorter” --Blaise Pascal