SQL表使用历史记录 [英] SQL Table usage history

问题描述

嗨团队，

我有一个名为PAYROLTABLE的重要表格，我们的IT策略说明谁会触发任何查询，如选择，更新，删除 在那张桌子上发生过，并且曾经像DBA或经理等那样访问过它，并且必须通过电子邮件向团体发送
。 

如何实现这一目标。任何sql查询??

---

hemadri

解决方案

SQL Server审计是你的朋友

https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-database-engine？视图= SQL服务器-2017

Hi team,

I have an important table named PAYROLTABLE , on which our IT policy says who ever triggers what ever the query it is like select, update, delete  etc. took place on that table and who ever accessed it like DBA or an manager etc has to be captured and sent in an email to an group . 

How to achieve this please. any sql query ??

---

hemadri

解决方案

SQL Server Audit is your friend here

https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-database-engine?view=sql-server-2017

这篇关于SQL表使用历史记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！