common criteria compliance enabled Option
The common criteria compliance enabled option enables the following elements that are required for the Common Criteria.
Residual Information Protection (RIP)
RIP requires a memory allocation to be overwritten with a known pattern of bits before memory is reallocated to a new resource. Meeting the RIP standard can contribute to improved security; however, overwriting the memory allocation can slow performance. After the common criteria compliance enabled option is enabled, the overwriting occurs.
The ability to view login statistics
After the common criteria compliance enabled option is enabled, login auditing is enabled. Each time a user successfully logs in to SQL Server, information about the last successful login time, the last unsuccessful login time, and the number of attempts between the last successful and current login times is made available. These login statistics can be viewed by querying the sys.dm_exec_sessions dynamic management view.
That column GRANT should not override table DENY
After the common criteria compliance enabled option is enabled, a table-level DENY takes precedence over a column-level GRANT. When the option is not enabled, a column-level GRANT takes precedence over a table-level DENY.
The common criteria compliance enabled option is an advanced option and is available in the Enterprise, Evaluation, and Developer editions of SQL Server. SQL Server 2008 has been evaluated against the Common Criteria at Evaluation Assurance Level 1 augmented (EAL1+). SQL Server 2008 is currently in evaluation at EAL4+ and to prove compliance with the NSA DBMS Protection Profile. For the latest information about these evaluations and how to enable compliance for SQL Server, see the Microsoft SQL Server Common Criteria Web site.
In addition to enabling the common criteria compliance enabled option, you also must download and run a script that finishes configuring SQL Server to comply with Common Criteria Evaluation Assurance Level 4+ (EAL4+). You can download this script from the Microsoft SQL Server Common Criteria Web site.
If you are using the sp_configure system stored procedure to change the setting, you can change common criteria compliance enabled only when show advanced options is set to 1. The setting takes effect after the server is restarted. The possible values are 0 and 1:
0 indicates that common criteria compliance is not enabled. This is the default.
1 indicates that common criteria compliance is enabled.
The following example enables common criteria compliance.
sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'common criteria compliance enabled', 1; GO RECONFIGURE GO