Minimum permissions required for the Predefined SQL CIS Standards in CCS

Products

• Control Compliance Suite Standards Database
• Control Compliance Suite

Issue/Introduction

What are the minimum permissions needed to perform data collection using the predefined SQL CIS Standards in Control Compliance Suite?

CIS Microsoft SQL Server 2016 Benchmark v1.3.0

CIS Microsoft SQL Server 2019 Benchmark v1.2.0

 

Resolution

Attached are 2 SQL scripts that will add the minimum permissions needed for the "CIS Microsoft SQL Server 2016 Benchmark v1.3.0", and "CIS Microsoft SQL Server 2019 Benchmark v1.2.0" to the SQL user account.