AzPolicyAdvertizer

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

Azure Policy definition

Public network access on Azure SQL Database should be disabled

Name Public network access on Azure SQL Database should be disabled
Azure Portal
Id 1b8ca024-1d5c-4dec-8995-b1a932b41780
Version 1.1.0
details on versioning
Category SQL
Microsoft docs
Description Disabling the public network access property improves security by ensuring your Azure SQL Database can only be accessed from a private endpoint. This configuration denies all logins that match IP or virtual network-based firewall rules.
Mode Indexed
Type BuiltIn
Preview FALSE
Deprecated FALSE
Effect Default: Audit
Allowed: (Audit, Deny, 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: Audit public network access setting for Azure SQL Database
2020-07-01 14:50:07 add 1b8ca024-1d5c-4dec-8995-b1a932b41780
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": "Public network access on Azure SQL Database should be disabled",
    "policyType": "BuiltIn",
    "mode": "Indexed",
    "description": "Disabling the public network access property improves security by ensuring your Azure SQL Database can only be accessed from a private endpoint. This configuration denies all logins that match IP or virtual network-based firewall rules.",
    "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",
          "Deny",
          "Disabled"
        ],
        "defaultValue": "Audit"
      }
    },
    "policyRule": {
      "if": {
        "allOf": [
          {
            "field": "type",
            "equals": "Microsoft.Sql/servers"
          },
          {
            "field": "Microsoft.Sql/servers/publicNetworkAccess",
            "notEquals": "Disabled"
          }
        ]
      },
      "then": {
      "effect": "[parameters('effect')]"
      }
    }
  },
  "id": "/providers/Microsoft.Authorization/policyDefinitions/1b8ca024-1d5c-4dec-8995-b1a932b41780",
  "type": "Microsoft.Authorization/policyDefinitions",
  "name": "1b8ca024-1d5c-4dec-8995-b1a932b41780"
}