AzPolicyAdvertizer

last sync: 2020-Jul-10 14:05:01 UTC

Azure Policy

PostgreSQL server should use a virtual network service endpoint

Policy DisplayName PostgreSQL server should use a virtual network service endpoint
Policy Id 3c14b034-bcb6-4905-94e7-5b8e98a47b65
Policy Category SQL
Policy Description This policy audits PostgreSQL servers not configured to use a virtual network service endpoint. For more details, visit https://aka.ms/postgresqlvnet.
Policy Mode Indexed
Policy Type BuiltIn
Policy in Preview FALSE
Policy Deprecated FALSE
Policy Effect Default: AuditIfNotExists
Allowed: (AuditIfNotExists,Disabled)
Roles used none
Policy Changes
Date/Time (UTC ymd) (i) Change Change detail
2020-02-27 09:26:21 add: Policy 3c14b034-bcb6-4905-94e7-5b8e98a47b65
Used in Policy Initiative(s) none
Policy Rule 
{
  "properties": {
    "displayName": "PostgreSQL server should use a virtual network service endpoint",
    "policyType": "BuiltIn",
    "mode": "Indexed",
    "description": "This policy audits PostgreSQL servers not configured to use a virtual network service endpoint. For more details, visit https://aka.ms/postgresqlvnet.",
    "metadata": {
      "version": "1.0.1",
      "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.DBforPostgreSQL/servers"
      },
      "then": {
      "effect": "[parameters('effect')]",
        "details": {
          "type": "Microsoft.DBforPostgreSQL/servers/virtualNetworkRules",
          "existenceCondition": {
            "field": "Microsoft.DBforPostgreSQL/servers/virtualNetworkRules/virtualNetworkSubnetId",
            "exists": "true"
          }
        }
      }
    }
  },
  "id": "/providers/Microsoft.Authorization/policyDefinitions/3c14b034-bcb6-4905-94e7-5b8e98a47b65",
  "type": "Microsoft.Authorization/policyDefinitions",
  "name": "3c14b034-bcb6-4905-94e7-5b8e98a47b65"
}