Policy: GCP > CIS v5.0 > 6 - Cloud SQL Database Services > 6.03 - SQL Server

Targets

This policy targets the following resource types:

• GCP > Project

Primary Policy

This policy is used with the following primary policy:

• GCP > CIS v5.0 > 6 - Cloud SQL Database Services

Related Policies

• 6.03.01 - Ensure 'external scripts enabled' Database Flag for Cloud SQL SQL Server Instance Is Set to 'off'
• 6.03.02 - Ensure 'cross db ownership chaining' Database Flag for Cloud SQL SQL Server Instance Is Set to 'off'
• 6.03.03 - Ensure 'user Connections' Database Flag for Cloud SQL SQL Server Instance Is Set to a Non-limiting Value
• 6.03.04 - Ensure 'user options' Database Flag for Cloud SQL SQL Server Instance Is Not Configured
• 6.03.05 - Ensure 'remote access' Database Flag for Cloud SQL SQL Server Instance Is Set to 'off'
• 6.03.06 - Ensure '3625 (trace flag)' Database Flag for all Cloud SQL SQL Server Instances Is Set to 'on'
• 6.03.07 - Ensure 'contained database authentication' Database Flag for Cloud SQL SQL Server Instance Is Set to 'off'

Controls

Setting this policy configures these controls:

• GCP > CIS v5.0 > 6 - Cloud SQL Database Services > 6.03 - SQL Server > 6.03.01 - Ensure 'external scripts enabled' Database Flag for Cloud SQL SQL Server Instance Is Set to 'off'
• GCP > CIS v5.0 > 6 - Cloud SQL Database Services > 6.03 - SQL Server > 6.03.02 - Ensure 'cross db ownership chaining' Database Flag for Cloud SQL SQL Server Instance Is Set to 'off'
• GCP > CIS v5.0 > 6 - Cloud SQL Database Services > 6.03 - SQL Server > 6.03.03 - Ensure 'user Connections' Database Flag for Cloud SQL SQL Server Instance Is Set to a Non-limiting Value
• GCP > CIS v5.0 > 6 - Cloud SQL Database Services > 6.03 - SQL Server > 6.03.04 - Ensure 'user options' Database Flag for Cloud SQL SQL Server Instance Is Not Configured
• GCP > CIS v5.0 > 6 - Cloud SQL Database Services > 6.03 - SQL Server > 6.03.05 - Ensure 'remote access' Database Flag for Cloud SQL SQL Server Instance Is Set to 'off'
• GCP > CIS v5.0 > 6 - Cloud SQL Database Services > 6.03 - SQL Server > 6.03.06 - Ensure '3625 (trace flag)' Database Flag for all Cloud SQL SQL Server Instances Is Set to 'on'
• GCP > CIS v5.0 > 6 - Cloud SQL Database Services > 6.03 - SQL Server > 6.03.07 - Ensure 'contained database authentication' Database Flag for Cloud SQL SQL Server Instance Is Set to 'off'

Policy Specification

string

Per GCP > CIS v5.0 > 6 - Cloud SQL Database Services

Category

• CIS

In Your Workspace

• Policy Settings by Type report

Developers

Category URI

tmod:@turbot/cis#/control/categories/cis

Policy Type URI

tmod:@turbot/gcp-cisv5-0#/policy/types/s0603

GraphQL

query policyType(id: "tmod:@turbot/gcp-cisv5-0#/policy/types/s0603") { … }

query policySettings(filter: "policyTypeId:'tmod:@turbot/gcp-cisv5-0#/policy/types/s0603'") { … }

query policyValues(filter: "policyTypeId:'tmod:@turbot/gcp-cisv5-0#/policy/types/s0603'") { … }

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/gcp-cisv5-0#/policy/types/s0603"

Get Policy Settings

turbot graphql policy-settings --filter "policyTypeId:tmod:@turbot/gcp-cisv5-0#/policy/types/s0603"