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
XXX










XXXX

X


X
ALTER TRACE Permission Granted To Unauthorized Users














X
XX

X



CONTROL SERVER Permission Granted To Unauthorized Users














X

X

X


X
Database File Owners Not Acceptable














X
XX

XX

X
Database File Permissions Not Acceptable














XXXX

XX


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



XXXXXXX




XXX






Everyone Database File Access














X
XX

XX

X
Everyone System Table Access














XXXX

X


X
Executable File Owners Not Acceptable














X

X

XX

X
Executable File Permissions Not Acceptable














XXXX

XX

X
Executable Files Missing Required Administrative Permissions

XX










X

X

X



Integration Services Roles Have Dangerous Security Principals














X
XX

X


X
Integration Services Roles Permissions Not Acceptable

XX










X
XX

X


X
Integration Services Users Permissions Not Acceptable















XXX






Limit Propagation of access rights










X




XX






Public Database Role Has Permissions
XXX









X
X

X
XXXX
Public Role Has Permissions on User Database Objects













XX
XX

X
X
X
Public Server Role Has Permissions













XXXXX

X
X

Public Server Role only granted default Microsoft permissions



XXXXXXX




XXX






Registry Key Owners Not Acceptable














X

X

XX

X
Registry Key Permissions Not Acceptable














X

X

XX

X
Registry Keys Missing Required Administrative Permissions














X

X

X



Sysadmins Own Databases














XXXX

X



IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal