开发者

How to tell if someone is looking at one of the records on your database?

I want to add some fake records/开发者_运维知识库rows for in the table for MS SQL 2008 Standard Edition database and use these records to monitor my database.

The purpose for this is to monitor hackers. It is possible to create a trigger to do this. It seemed like the DDL Triggers can not do this tasks.


If you can't control access to your database via stored procedures (where you could add your own logging), you will need to use auditing or server-side trace for this. There is no such thing as a select trigger and there are no DMVs that will tell you which rows were looked at via any select action.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜