Click on the Policy Template name to order the table according to Security Checks marked as default.
Access Security Checks | CIS for SQL Server 2000 | CIS for SQL Server 2005 | CIS for SQL Server 2008 | CIS for SQL Server 2008 R2 | CIS for SQL Server 2012 | CIS for SQL Server 2014 | CIS for SQL Server 2016 | CIS for SQL Server 2017 | CIS for SQL Server 2019 | CIS for SQL Server 2022 | DISA-NIST STIG for SQL Server 2012 | DISA-NIST STIG for SQL Server 2014 | DISA-NIST STIG for SQL Server 2016 | European Union General Data Protection Regulation (GDPR) | HIPAA Guidelines for SQL Server | IDERA Level 1 - Basic Protection | IDERA Level 2 - Balanced Protection | IDERA Level 3 - Strong Protection | MS Best Practices Analyzer | NERC Critical Infrastructure Protection | PCI-DSS Guidelines for SQL Server | SNAC for SQL 2000 | SOX Section 404 | SRR Checklist for SQL Server 2000 | SRR Checklist for SQL Server 2005 or later |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Agent Job Execution | X | X | X | X | X | X | X | X | X | ||||||||||||||||
ALTER TRACE Permission Granted To Unauthorized Users | X | X | X | X | |||||||||||||||||||||
CONTROL SERVER Permission Granted To Unauthorized Users | X | X | X | X | |||||||||||||||||||||
Database File Owners Not Acceptable | X | X | X | X | X | X | |||||||||||||||||||
Database File Permissions Not Acceptable | X | X | X | X | X | X | |||||||||||||||||||
Database Files Missing Required Administrative Permissions | X | X | X | ||||||||||||||||||||||
Direct Access Permissions | X | X | |||||||||||||||||||||||
Ensure public role is not granted access SQL Agent proxies in msdb database | X | X | X | X | X | X | X | X | X | X | |||||||||||||||
Everyone Database File Access | X | X | X | X | X | X | |||||||||||||||||||
Everyone System Table Access | X | X | X | X | X | X | |||||||||||||||||||
Executable File Owners Not Acceptable | X | X | X | X | X | ||||||||||||||||||||
Executable File Permissions Not Acceptable | X | X | X | X | X | X | X | ||||||||||||||||||
Executable Files Missing Required Administrative Permissions | X | X | X | X | X | ||||||||||||||||||||
Integration Services Roles Have Dangerous Security Principals | X | X | X | X | X | ||||||||||||||||||||
Integration Services Roles Permissions Not Acceptable | X | X | X | X | X | X | X | ||||||||||||||||||
Integration Services Users Permissions Not Acceptable | X | X | X | ||||||||||||||||||||||
Limit Propagation of access rights | X | X | X | ||||||||||||||||||||||
Public Database Role Has Permissions | X | X | X | X | X | X | X | X | X | X | |||||||||||||||
Public Role Has Permissions on User Database Objects | X | X | X | X | X | X | X | ||||||||||||||||||
Public Server Role Has Permissions | X | X | X | X | X | X | X | ||||||||||||||||||
Public Server Role only granted default Microsoft permissions | X | X | X | X | X | X | X | X | X | X | |||||||||||||||
Registry Key Owners Not Acceptable | X | X | X | X | X | ||||||||||||||||||||
Registry Key Permissions Not Acceptable | X | X | X | X | X | ||||||||||||||||||||
Registry Keys Missing Required Administrative Permissions | X | X | X | ||||||||||||||||||||||
Sysadmins Own Databases | X | X | X | X | X |