设置并查看数据库的C2审计的结果
- 作者: 灬小文-
- 来源: 51数据库
- 2022-08-17
EXEC sp_configure 'show advanced option', 1;
EXEC sp_configure 'c2 audit mode', '1' RECONFIGURE;
EXEC sp_configure 'c2 audit mode', '0' RECONFIGURE;
EXEC sp_configure 'common criteria compliance enable',1;
select * from sys.traces
-- Reads from a file that is named \\serverName\Audit\HIPPA_AUDIT.sqlaudit
SELECT * FROM sys.fn_get_audit_file ('C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\audittrace20130216145422.trc',default,default);
GO
推荐阅读
