last sync: 2021-Jan-15 16:07:21 UTC

Azure Policy definition

Private endpoint connections on Azure SQL Database should be enabled

Name Private endpoint connections on Azure SQL Database should be enabled
Azure Portal
Id 7698e800-9299-47a6-b3b6-5a0fee576eed
Version 1.1.0
details on versioning
Category SQL
Microsoft docs
Description When using private endpoints for Azure SQL Database, traffic is secured to a specific private link resource. The platform performs an access control to validate network connections reaching only the specified private link resource. This control provides an additional network security layer to your resources by providing a built-in exfiltration protection that prevents access to other resources hosted on the same Azure service.
Mode Indexed
Type BuiltIn
Preview FALSE
Deprecated FALSE
Effect Default: Audit
Allowed: (Audit, Disabled)
Used RBAC Role none
History
Date/Time (UTC ymd) (i) Change type Change detail
2021-01-13 16:08:35 change Minor (1.0.1 > 1.1.0)
2020-12-11 15:42:52 change Patch (1.0.0 > 1.0.1) *changes on text case sensitivity are not tracked
2020-07-08 14:28:08 change Previous DisplayName: Azure SQL Databases should have private endpoint connections
2020-07-01 14:50:07 add 7698e800-9299-47a6-b3b6-5a0fee576eed
Used in Initiatives
Initiative DisplayName Initiative Id Initiative Category State
[Preview]: Azure Security Benchmark v2 bb522ac1-bc39-4957-b194-429bcd3bcb0b Regulatory Compliance Preview
JSON Changes

Json
{
  "properties": {
    "displayName": "Private endpoint connections on Azure SQL Database should be enabled",
    "policyType": "BuiltIn",
    "mode": "Indexed",
    "description": "When using private endpoints for Azure SQL Database, traffic is secured to a specific private link resource. The platform performs an access control to validate network connections reaching only the specified private link resource. This control provides an additional network security layer to your resources by providing a built-in exfiltration protection that prevents access to other resources hosted on the same Azure service.",
    "metadata": {
      "version": "1.1.0",
      "category": "SQL"
    },
    "parameters": {
      "effect": {
        "type": "String",
        "metadata": {
          "displayName": "Effect",
          "description": "Enable or disable the execution of the policy"
        },
        "allowedValues": [
          "Audit",
          "Disabled"
        ],
        "defaultValue": "Audit"
      }
    },
    "policyRule": {
      "if": {
        "allOf": [
          {
            "field": "type",
            "equals": "Microsoft.Sql/servers"
          },
          {
            "count": {
            "field": "Microsoft.Sql/servers/privateEndpointConnections[*]",
              "where": {
              "field": "Microsoft.Sql/servers/privateEndpointConnections[*].privateLinkServiceConnectionState.status",
                "equals": "Approved"
              }
            },
            "less": 1
          }
        ]
      },
      "then": {
      "effect": "[parameters('effect')]"
      }
    }
  },
  "id": "/providers/Microsoft.Authorization/policyDefinitions/7698e800-9299-47a6-b3b6-5a0fee576eed",
  "type": "Microsoft.Authorization/policyDefinitions",
  "name": "7698e800-9299-47a6-b3b6-5a0fee576eed"
}