开发者

SQL Server 2008: Can I view past user actions?

开发者 https://www.devze.com 2023-03-14 20:33 出处:网络
I am fairly new to SQL Server administration and was wondering if there is a way to query the system to开发者_开发知识库 track user actions.The user has appropriate permissions.I would just like to se

I am fairly new to SQL Server administration and was wondering if there is a way to query the system to开发者_开发知识库 track user actions. The user has appropriate permissions. I would just like to see what they are doing each day.

I'm wondering two main things: 1) Can I see a history of tables they've only VIEWED? 2) Can I see a history of tables they've MODIFIED (insert, update, delete)?

Many thanks in advance!

-->> S.K.


I know the following approach:

  1. Launch SQL Server Profiler to write logs
  2. Enable Auditing
0

精彩评论

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