如何实施审核? [英] How to implement Audit?

问题描述

用户执行某些操作，例如下订单，删除订单..

如何在SQL表中实施审核?请指导我.

解决方案

这里是类似的线程
SQL Server中的审计试用版跟踪表中的更改 [此处 [ ^ ]

您可以在要监视的表上创建插入/更新/删除触发器.

检查以下链接

http://stackoverflow.com/questions/4200407/table-history-trigger-in- sql-server [ ^ ]

或者您可以使用，
MSDN:ChangeTable [

SQL Server数据库触发器概述 [ ^ ]

Triggers-Sql Server [ ^ ]

User performs some operation say for example Place an order, Delete an order..

How to implement Auditing in SQL table? Please guide me.

解决方案

Here is a similar thread
Audit trial in sql server to track changes in the table[^]

More resources here[^]

Hi,

You can create Insert/Update/Delete triggers on tables that you would like to monitor.

Check below link

http://stackoverflow.com/questions/4200407/table-history-trigger-in-sql-server[^]

Or you can use,
MSDN : ChangeTable[^] But this will work on SQL server 2008 /R2

Thanks
-Amit Gajjar

You can Create Trigger on Main Table For Insert , Update and Delete to fetch all actions on Table.



Overview of SQL Server database Triggers[^]

Triggers -- Sql Server[^]

这篇关于如何实施审核?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！