Azure CIS v2.0.0 - Section 4 - Database Services

This section covers security recommendations to follow to set general database services policies on an Azure Subscription. Subsections will address specific database types.

This policy pack can help you automate the enforcement of Azure CIS benchmark section 4 best practices.

Review policy settings →

Getting Started

Requirements

Terraform
Guardrails mods:

Credentials

To create a policy pack through Terraform:

Ensure you have Turbot/Admin permissions (or higher) in Guardrails
Create access keys in Guardrails

And then set your credentials:

export TURBOT_WORKSPACE=myworkspace.acme.com
export TURBOT_ACCESS_KEY=acce6ac5-access-key-here
export TURBOT_SECRET_KEY=a8af61ec-secret-key-here

Please see Turbot Guardrails Provider authentication for additional authentication methods.

Usage

Install Policy Pack

Note
By default, installed policy packs are not attached to any resources.

Policy packs must be attached to resources in order for their policy settings to take effect.

Clone:

git clone https://github.com/turbot/guardrails-samples.git
cd guardrails-samples/policy_packs/azure/cis_v200/section4

Run the Terraform to create the policy pack in your workspace:

terraform init
terraform plan

Then apply the changes:

terraform apply

Apply Policy Pack

Log into your Guardrails workspace and attach the policy pack to a resource.

If this policy pack is attached to a Guardrails folder, its policies will be applied to all accounts and resources in that folder. The policy pack can also be attached to multiple resources.

For more information, please see Policy Packs.

Enable Enforcement

Tip
You can also update the policy settings in this policy pack directly in the Guardrails console.

Please note your Terraform state file will then become out of sync and the policy settings should then only be managed in the console.

By default, the policies are set to Check in the pack's policy settings. To enable automated enforcements, you can switch these policies settings by adding a comment to the Check setting and removing the comment from one of the listed enforcement options:

resource "turbot_policy_setting" "azure_sql_server_auditing" {
  resource = turbot_policy_pack.main.id
  type     = "tmod:@turbot/azure-sql#/policy/types/serverAuditing"
  note     = "Azure CIS v2.0.0 - Control: 4.1.1, 4.1.6"
  # value   = "Check: Enabled"
  value    = "Enforce: Enabled"
}

resource "turbot_policy_setting" "azure_network_network_security_group_ingress_rules_approved" {
  resource = turbot_policy_pack.main.id
  type     = "tmod:@turbot/azure-network#/policy/types/networkSecurityGroupIngressRulesApproved"
  note     = "Azure CIS v2.0.0 - Control: 4.1.2"
  # value   = "Check: Approved"
  value    = "Enforce: Delete unapproved if new"
}

resource "turbot_policy_setting" "azure_sql_server_active_directory_administrator" {
  resource = turbot_policy_pack.main.id
  type     = "tmod:@turbot/azure-sql#/policy/types/serverActiveDirectoryAdministrator"
  note     = "Azure CIS v2.0.0 - Control: 4.1.4"
  # value   = "Check: Enabled to Active Directory Administrator > Name"
  value    = "Enforce: Enabled to Active Directory Administrator > Name"
}

resource "turbot_policy_setting" "azure_sql_database_encryption_at_rest" {
  resource = turbot_policy_pack.main.id
  type     = "tmod:@turbot/azure-sql#/policy/types/databaseEncryptionAtRest"
  note     = "Azure CIS v2.0.0 - Control: 4.1.5"
  # value   = "Check: Enabled"
  value    = "Enforce: Enabled"
}

resource "turbot_policy_setting" "azure_sql_server_data_security" {
  resource = turbot_policy_pack.main.id
  type     = "tmod:@turbot/azure-sql#/policy/types/serverDataSecurity"
  note     = "Azure CIS v2.0.0 - Control: 4.2.1, 4.2.2, 4.2.3, 4.2.4 and 4.2.5"
  # value   = "Check: Enabled"
  value    = "Enforce: Enabled"
}

resource "turbot_policy_setting" "azure_postgresql_server_encryption_in_transit" {
  resource = turbot_policy_pack.main.id
  type     = "tmod:@turbot/azure-postgresql#/policy/types/serverEncryptionInTransit"
  note     = "Azure CIS v2.0.0 - Control: 4.3.1"
  # value   = "Check: Enabled"
  value    = "Enforce: Enabled"
}

resource "turbot_policy_setting" "azure_postgresql_flexible_server_encryption_in_transit" {
  resource = turbot_policy_pack.main.id
  type     = "tmod:@turbot/azure-postgresql#/policy/types/flexibleServerEncryptionInTransit"
  note     = "Azure CIS v2.0.0 - Control: 4.3.1"
  # value   = "Check: Enabled"
  value    = "Enforce: Enabled"
}

resource "turbot_policy_setting" "azure_postgresql_server_audit_logging" {
  resource = turbot_policy_pack.main.id
  type     = "tmod:@turbot/azure-postgresql#/policy/types/serverAuditLogging"
  note     = "Azure CIS v2.0.0 - Control: 4.3.2, 4.3.3, 4.3.4, 4.3.5, 4.3.6, 4.3.7 and 4.3.8"
  # value   = "Check: Audit Logging > *"
  value    = "Enforce: Audit Logging > *"
}

resource "turbot_policy_setting" "azure_postgresql_flexible_server_audit_logging" {
  resource = turbot_policy_pack.main.id
  type     = "tmod:@turbot/azure-postgresql#/policy/types/flexibleServerAuditLogging"
  note     = "Azure CIS v2.0.0 - Control: 4.3.2"
  # value   = "Check: Audit Logging > *"
  value    = "Enforce: Audit Logging > *"
}

resource "turbot_policy_setting" "azure_postgresql_server_approved" {
  resource = turbot_policy_pack.main.id
  type     = "tmod:@turbot/azure-postgresql#/policy/types/serverApproved"
  note     = "Azure CIS v2.0.0 - Control: 4.3.7 and 4.3.8"
  # value   = "Check: Approved"
  value    = "Enforce: Delete unapproved if new"
}

resource "turbot_policy_setting" "azure_mysql_server_encryption_in_transit" {
  resource = turbot_policy_pack.main.id
  type     = "tmod:@turbot/azure-mysql#/policy/types/serverEncryptionInTransit"
  note     = "Azure CIS v2.0.0 - Control: 4.4.1"
  # value   = "Check: Enabled"
  value    = "Enforce: Enabled"
}

resource "turbot_policy_setting" "azure_mysql_flexible_server_encryption_in_transit" {
  resource = turbot_policy_pack.main.id
  type     = "tmod:@turbot/azure-mysql#/policy/types/flexibleServerEncryptionInTransit"
  note     = "Azure CIS v2.0.0 - Control: 4.4.1"
  # value   = "Check: Enabled"
  value    = "Enforce: Enabled"
}

resource "turbot_policy_setting" "azure_mysql_flexible_server_minimum_tls_version" {
  resource = turbot_policy_pack.main.id
  type     = "tmod:@turbot/azure-mysql#/policy/types/flexibleServerMinimumTlsVersion"
  note     = "Azure CIS v2.0.0 - Control: 4.4.2"
  #value    = "Check: TLS 1.2"
  value    = "Enforce: TLS 1.2"
}

resource "turbot_policy_setting" "azure_cosmosdb_database_account_firewall" {
  resource = turbot_policy_pack.main.id
  type     = "tmod:@turbot/azure-cosmosdb#/policy/types/databaseAccountFirewall"
  note     = "Azure CIS v2.0.0 - Control: 4.5.1"
  # value    = "Check: Allow only approved virtual networks and IP ranges"
  value    = "Enforce: Allow only approved virtual networks and IP ranges"
}

resource "turbot_policy_setting" "azure_cosmosdb_database_account_firewall_ip_ranges_required" {
  resource = turbot_policy_pack.main.id
  type     = "tmod:@turbot/azure-cosmosdb#/policy/types/databaseAccountFirewallIpRangesRequired"
  note     = "Azure CIS v2.0.0 - Control: 4.5.1"
  # value    = "Check: Required > Items"
  value    = "Enforce: Required > Items"
}

resource "turbot_policy_setting" "azure_cosmosdb_database_account_firewall_virtual_networks_required" {
  resource = turbot_policy_pack.main.id
  type     = "tmod:@turbot/azure-cosmosdb#/policy/types/databaseAccountFirewallVirtualNetworksRequired"
  note     = "Azure CIS v2.0.0 - Control: 4.5.1"
  # value    = "Check: Required > Items"
  value    = "Enforce: Required > Items"
}

Then re-apply the changes:

terraform plan
terraform apply