如何查找哪个用户已执行INSERT，UPDATE&在ASDWH中删除 [英] How to find which user has perform INSERT , UPDATE & DELETE in ASDWH

问题描述

1.我们如何访问日志以找出哪个用户执行了INSERT，UPDATE&在ASDWH中删除.

1.How do we access the log to figure out which user has perform INSERT , UPDATE & DELETE in ASDWH .

2.插入，更新，删除了多少行

2. How many rows got Inserted , Updated , Deleted

3.执行查询需要什么权限.

3.What permission are required to execute the queries.

请提出建议

推荐答案

SubhadipRoy，

Hi SubhadipRoy,

请查看以下文档，该文档将说明如何审核特定事件和所需的配置: 在Azure SQL数据仓库中进行审核

Please take a look at the following documentation, which will explain how to audit specific events and the configuration required: Auditing in Azure SQL Data Warehouse

如果您还有其他问题，请告诉我.谢谢！

Please let me know if you have additional questions. Thank you!

这篇关于如何查找哪个用户已执行INSERT，UPDATE&在ASDWH中删除的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！