AzPolicyAdvertizer

last sync: 2021-Oct-25 16:02:14 UTC

Azure Policy definition

MySQL servers should use customer-managed keys to encrypt data at rest

Name MySQL servers should use customer-managed keys to encrypt data at rest
Azure Portal
Id 83cef61d-dbd1-4b20-a4fc-5fbc7da10833
Version 1.0.4
details on versioning
Category SQL
Microsoft docs
Description Use customer-managed keys to manage the encryption at rest of your MySQL servers. By default, the data is encrypted at rest with service-managed keys, but customer-managed keys are commonly required to meet regulatory compliance standards. Customer-managed keys enable the data to be encrypted with an Azure Key Vault key created and owned by you. You have full control and responsibility for the key lifecycle, including rotation and management.
Mode Indexed
Type BuiltIn
Preview FALSE
Deprecated FALSE
Effect Default: AuditIfNotExists
Allowed: (AuditIfNotExists, Disabled)
Used RBAC Role none
History
Date/Time (UTC ymd) (i) Change type Change detail
2021-05-26 13:43:16 change Patch (1.0.3 > 1.0.4) *changes on text case sensitivity are not tracked
2021-02-10 14:43:58 change Patch (1.0.2 > 1.0.3) *changes on text case sensitivity are not tracked
2020-12-11 15:42:52 change Patch (1.0.1 > 1.0.2) *changes on text case sensitivity are not tracked
2020-04-28 14:50:57 add 83cef61d-dbd1-4b20-a4fc-5fbc7da10833
Used in Initiatives
Initiative DisplayName Initiative Id Initiative Category State
[Deprecated]: Azure Security Benchmark v2 bb522ac1-bc39-4957-b194-429bcd3bcb0b Regulatory Compliance Deprecated
[Preview]: NIST SP 800-53 Rev. 5 179d1daa-458f-4e47-8086-2a68d0d6c38f Regulatory Compliance Preview
Azure Security Benchmark 1f3afdf9-d0c9-4c3d-847f-89da613e70a8 Security Center GA
FedRAMP High d5264498-16f4-418a-b659-fa7ef418175f Regulatory Compliance GA
FedRAMP Moderate e95f5a9f-57ad-4d03-bb0b-b1d16db93693 Regulatory Compliance GA
New Zealand ISM Restricted d1a462af-7e6d-4901-98ac-61570b4ed22a Regulatory Compliance GA
NIST SP 800-53 Rev. 4 cf25b9c1-bd23-4eb6-bd2c-f4f3ac644a5f Regulatory Compliance GA
JSON Changes

JSON 
{
  "displayName": "MySQL servers should use customer-managed keys to encrypt data at rest",
  "policyType": "BuiltIn",
  "mode": "Indexed",
  "description": "Use customer-managed keys to manage the encryption at rest of your MySQL servers. By default, the data is encrypted at rest with service-managed keys, but customer-managed keys are commonly required to meet regulatory compliance standards. Customer-managed keys enable the data to be encrypted with an Azure Key Vault key created and owned by you. You have full control and responsibility for the key lifecycle, including rotation and management.",
  "metadata": {
    "version": "1.0.4",
    "category": "SQL"
  },
  "parameters": {
    "effect": {
      "type": "String",
      "metadata": {
        "displayName": "Effect",
        "description": "Enable or disable the execution of the policy"
      },
      "allowedValues": [
        "AuditIfNotExists",
        "Disabled"
      ],
      "defaultValue": "AuditIfNotExists"
    }
  },
  "policyRule": {
    "if": {
      "field": "type",
      "equals": "Microsoft.DBforMySQL/servers"
    },
    "then": {
      "effect": "[parameters('effect')]",
      "details": {
        "type": "Microsoft.DBforMySQL/servers/keys",
        "existenceCondition": {
          "allOf": [
            {
              "field": "Microsoft.DBforMySQL/servers/keys/serverKeyType",
              "equals": "AzureKeyVault"
            },
            {
              "field": "Microsoft.DBforMySQL/servers/keys/uri",
              "notEquals": ""
            },
            {
              "field": "Microsoft.DBforMySQL/servers/keys/uri",
              "exists": "true"
            }
          ]
        }
      }
    }
  }
}