设置并查看数据库的C2审计的结果 无 EXEC sp_configure ‘show advanced option’, 1;EXEC sp_configure ‘c2 本文来源gao@!dai!ma.com搞$$代^@码!网!audit mode’, ‘1’ RECONFIGURE;EXEC sp_configure ‘c2 audit mode’, ‘0’ RECONFIGURE;EXEC sp_configure ‘common criteria compliance enable’,1;sele
设置并查看数据库的C2审计的结果 <style> .CodeEntity .code_pieces ul.piece_anchor{width:25px;position:absolute;top:25px;left:-30px;z-index:1000;} .CodeEntity .code_pieces ul.piece_anchor li{width:25px;background: #efe;margin-bottom:2px;} .CodeEntity .code_pieces ul.piece_anchor li{border-left:3px #40AA63 solid;border-right:3px #efe solid;} .CodeEntity .code_pieces ul.piece_anchor li:hover{border-right:3px #40AA63 solid;border-left:3px #efe solid;} .CodeEntity .code_pieces ul.piece_anchor li a{color: #333;padding: 3px 10px;} .CodeEntity .code_pieces .jump_to_code{visibility:hidden;position:relative;} .CodeEntity .code_pieces .code_piece:hover .jump_to_code{visibility:visible;} .CodeEntity .code_pieces .code_piece:hover .jump_to_code a{text-decoration:none;} .CodeEntity .code_pieces h2 i{float:right;font-style:normal;font-weight:normal;} .CodeEntity .code_pieces h2 i a{font-size:9pt;background: #FFFFFF;color:#00A;padding: 2px 5px;text-decoration:none;} </style> <!—ecms
- –> <!—ecms
- $velocityCount
–> <!—ecms
–>
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
转载请注明原文链接：设置并查看数据库的C2审计的结果
