c2 audit mode
Type: Advanced; requires a reboot of SQL Server to take effect
Default value: 0
C2 audit mode can be configured through SSMS or with the c2 audit mode option in sp_configure. This feature is still available. Selecting this option configures the server to record both failed and successful attempts to access statements and objects. This information can help you profile system activity and track possible security policy violations. The C2 security standard has been superseded by common criteria compliance features. Much of the detail-level auditing is now done with SQL Auditing (covered in the SQL Server Security chapters) and is far more robust than this feature. C2 audit mode data is saved in a file in the default data directory ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
