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

Azure Policy

Public network access on Azure SQL Database should be disabled

Name Public network access on Azure SQL Database should be disabled
Id 1b8ca024-1d5c-4dec-8995-b1a932b41780
Version 1.0.0
details on versioning
Category SQL
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 Fixed: audit
Used RBAC Role none
History
Date/Time (UTC ymd) (i) Change type Change detail
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 none
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.0.0",
      "category": "SQL"
    },
    "parameters": {
      
    },
    "policyRule": {
      "if": {
        "allOf": [
          {
            "field": "type",
            "equals": "Microsoft.Sql/servers"
          },
          {
            "field": "Microsoft.Sql/servers/publicNetworkAccess",
            "notEquals": "Disabled"
          }
        ]
      },
      "then": {
        "effect": "audit"
      }
    }
  },
  "id": "/providers/Microsoft.Authorization/policyDefinitions/1b8ca024-1d5c-4dec-8995-b1a932b41780",
  "type": "Microsoft.Authorization/policyDefinitions",
  "name": "1b8ca024-1d5c-4dec-8995-b1a932b41780"
}