Policy: Azure > CIS v3.0 > 05 - Database Services > 05.01 - Azure SQL Database > 05.01.05 - Ensure that 'Data encryption' is set to 'On' on a SQL Database

Configures auditing against a CIS Benchmark item.

Level: 1

Enable Transparent Data Encryption on every SQL server.

Azure SQL Database transparent data encryption helps protect against the threat of malicious activity by performing real-time encryption and decryption of the database, associated backups, and transaction log files at rest without requiring changes to the application.

Targets

This policy targets the following resource types:

Azure > SQL > Database

Primary Policy

This policy is used with the following primary policy:

Azure > CIS v3.0 > 05 - Database Services > 05.01 - Azure SQL Database

Controls

Setting this policy configures this control:

Azure > CIS v3.0 > 05 - Database Services > 05.01 - Azure SQL Database > 05.01.05 - Ensure that 'Data encryption' is set to 'On' on a SQL Database

Policy Specification

Schema Type	`string`
Default	`Per Azure > CIS v3.0 > 05 - Database Services`
Valid Values [YAML]	`Per Azure > CIS v3.0 > 05 - Database Services` `Skip` `Check: Benchmark`

In Your Workspace

Policy Settings by Type report

Developers

Category URI

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

Policy Type URI

tmod:@turbot/azure-cisv3-0#/policy/types/r050105

GraphQL

query policyType(id: "tmod:@turbot/azure-cisv3-0#/policy/types/r050105") { … }

query policySettings(filter: "policyTypeId:'tmod:@turbot/azure-cisv3-0#/policy/types/r050105'") { … }

query policyValues(filter: "policyTypeId:'tmod:@turbot/azure-cisv3-0#/policy/types/r050105'") { … }

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/azure-cisv3-0#/policy/types/r050105"

Get Policy Settings

turbot graphql policy-settings --filter "policyTypeId:tmod:@turbot/azure-cisv3-0#/policy/types/r050105"