修改数据库的审计,可以删除掉现有策略,然后重新创建;也可以在现有策略上修改。 下面介绍一下在现有策略上修改的方法和步骤:
ALTER DATABASE AUDIT SPECIFICATION [Audit Name] --Audit Name为要修改的审计名称
WITH (STATE=OFF)
ALTER DATABASE AUDIT SPECIFICATION [Audit Name] --Audit Name为要修改的审计名称
FOR SERVER AUDIT [RDSAUDIT]
DROP (SELECT ON OBJECT::[DBO].[tb1] BY [USER1]),
DROP (INSERT ON OBJECT::[DBO].[tb2] BY [USER1]),
ADD (DELETE ON OBJECT::[DBO].[tb2] BY [USER1])
WITH (STATE=ON)
详细的语法,可以参考微软的官方文档 ALTER DATABASE AUDIT SPECIFICATION