last sync: 2020-Oct-20 13:29:33 UTC

Azure Policy

Transparent Data Encryption on SQL databases should be enabled

Name Transparent Data Encryption on SQL databases should be enabled
Id 17k78e20-9358-41c9-923c-fb736d382a12
Version 1.0.0
details on versioning
Category SQL
Description Transparent data encryption should be enabled to protect data-at-rest and meet compliance requirements
Mode Indexed
Type BuiltIn
Preview FALSE
Deprecated FALSE
Effect Default: AuditIfNotExists
Allowed: (AuditIfNotExists,Disabled)
Used RBAC Role none
History none
Used in Initiatives
Initiative DisplayName Initiative Id
[Deprecated]: DOD Impact Level 4 8d792a84-723c-4d92-a3c3-e4ed16a2d133
[Preview]: Australian Government ISM PROTECTED 27272c0b-c225-4cc3-b8b0-f2534b093077
[Preview]: Azure Security Benchmark 42a694ed-f65e-42b2-aa9e-8052e9740a92
[Preview]: Motion Picture Association of America (MPAA) 92646f03-e39d-47a9-9e24-58d60ef49af8
[Preview]: NIST SP 800-171 R2 03055927-78bd-4236-86c0-f36125a10dc9
[Preview]: SWIFT CSP-CSCF v2020 3e0c67fc-8c7c-406c-89bd-6b6bdc986a22
Canada Federal PBMM 4c4a5f27-de81-430b-b4e5-9cbd50595a87
CIS Microsoft Azure Foundations Benchmark 1.1.0 1a5bb27d-173f-493e-9568-eb56638dde4d
Enable Monitoring in Azure Security Center 1f3afdf9-d0c9-4c3d-847f-89da613e70a8
FedRAMP High d5264498-16f4-418a-b659-fa7ef418175f
FedRAMP Moderate e95f5a9f-57ad-4d03-bb0b-b1d16db93693
HITRUST/HIPAA a169a624-5599-4385-a696-c8d643089fab
IRS1075 September 2016 105e0327-6175-4eb2-9af4-1fba43bdb39d
ISO 27001:2013 89c6cddc-1c73-4ac1-b19c-54d1a15a42f2
ISO 27001:2013 89c6cddc-1c73-4ac1-b19c-54d1a15a42f2
NIST SP 800-53 R4 cf25b9c1-bd23-4eb6-bd2c-f4f3ac644a5f
PCI v3.2.1:2018 496eeda9-8f2f-4d5e-8dfd-204f0a92ed41
PCI v3.2.1:2018 496eeda9-8f2f-4d5e-8dfd-204f0a92ed41
UK OFFICIAL and UK NHS 3937f550-eedd-4639-9c5e-294358be442e
Json
{
  "properties": {
    "displayName": "Transparent Data Encryption on SQL databases should be enabled",
    "policyType": "BuiltIn",
    "mode": "Indexed",
    "description": "Transparent data encryption should be enabled to protect data-at-rest and meet compliance requirements",
    "metadata": {
      "version": "1.0.0",
      "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": {
        "allOf": [
          {
            "field": "type",
            "equals": "Microsoft.Sql/servers/databases"
          },
          {
            "field": "name",
            "notEquals": "master"
          }
        ]
      },
      "then": {
      "effect": "[parameters('effect')]",
        "details": {
          "type": "Microsoft.Sql/servers/databases/transparentDataEncryption",
          "name": "current",
          "existenceCondition": {
            "allOf": [
              {
                "field": "Microsoft.Sql/transparentDataEncryption.status",
                "equals": "enabled"
              }
            ]
          }
        }
      }
    }
  },
  "id": "/providers/Microsoft.Authorization/policyDefinitions/17k78e20-9358-41c9-923c-fb736d382a12",
  "type": "Microsoft.Authorization/policyDefinitions",
  "name": "17k78e20-9358-41c9-923c-fb736d382a12"
}