SQL Server审核，在谁的数据库级别上。在sql 2008 std版本中 [英] SQL Server Auditing , on who DB level . in sql 2008 std version

问题描述

嗨 

我想知道是否有任何机制可以监控谁在我的数据库中的任何表上发出删除声明的问题。 

他们也有问题的声明。 

如何监控和捕获这些记录。 

你可以吗？请帮我做。

我使用的是sql 2008标准版。 

---

hemadri

解决方案

如果在恢复模式上运行删除并且为时不晚，则可以使用函数
fn_dblog 扫描日志，看看是谁做的。我们无法保证将用户返回给用户，因为它本可以在dbo 用户下运行。 

请尝试以下链接中给出的示例。

https://dba.stackexchange。 com / questions / 4269 / how-to-out-out-who-deleted-some-data-sql-server

https://www.mssqltips.com / sqlservertip / 3090 / how-to-user-who-run-drop-or-delete-statements-on-your-sql-server-objects /

Hi 

I would like to know is there any mechanism to monitor who ever has issues an delete statement on any tables in my Database . 

Also the statement they have issues . 

how to monitor and capture those records . 

can you please help me to do it .

i am using sql 2008 standard version . 

---

hemadri

解决方案

If it's not too late since the delete was run and contingent upon your recovery model, you can use the function fn_dblog to scan the log and see who did it. It's not guaranteed to return you the user as it could have been run under dbo user. 

Try the examples given in the following links.

https://dba.stackexchange.com/questions/4269/how-to-find-out-who-deleted-some-data-sql-server

https://www.mssqltips.com/sqlservertip/3090/how-to-find-user-who-ran-drop-or-delete-statements-on-your-sql-server-objects/

这篇关于SQL Server审核，在谁的数据库级别上。在sql 2008 std版本中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！