last sync: 2020-Jul-02 13:28:37 UTC

Azure Policy

[Deprecated]: Audit SQL DB Level Audit Setting

Policy DisplayName [Deprecated]: Audit SQL DB Level Audit Setting
Policy Id 06a78e20-9358-41c9-923c-fb736d382a12
Policy Category SQL
Policy Description Audit DB level audit setting for SQL databases
Policy Mode All
Policy Type BuiltIn
Policy in Preview FALSE
Policy Deprecated True
Policy Effect Fixed: AuditIfNotExists
Roles used none
Policy Changes
Date/Time (UTC ymd) (i) Change Change detail
2019-10-08 15:55:12 change: DisplayName previous DisplayName: Audit SQL DB Level Audit Setting
Used in Policy Initiative(s) none
Policy Rule
{
  "properties": {
  "displayName": "[Deprecated]: Audit SQL DB Level Audit Setting",
    "policyType": "BuiltIn",
    "mode": "All",
    "description": "Audit DB level audit setting for SQL databases",
    "metadata": {
      "version": "1.0.0-deprecated",
      "category": "SQL",
      "deprecated": true
    },
    "parameters": {
      "setting": {
        "type": "String",
        "metadata": {
        "displayName": "[Deprecated]: Audit Setting"
        },
        "allowedValues": [
          "enabled",
          "disabled"
        ]
      }
    },
    "policyRule": {
      "if": {
        "allOf": [
          {
            "field": "type",
            "equals": "Microsoft.Sql/servers/databases"
          },
          {
            "field": "name",
            "notEquals": "master"
          }
        ]
      },
      "then": {
        "effect": "AuditIfNotExists",
        "details": {
          "type": "Microsoft.Sql/servers/databases/auditingSettings",
          "name": "default",
          "existenceCondition": {
            "allOf": [
              {
                "field": "Microsoft.Sql/auditingSettings.state",
              "equals": "[parameters('setting')]"
              }
            ]
          }
        }
      }
    }
  },
  "id": "/providers/Microsoft.Authorization/policyDefinitions/06a78e20-9358-41c9-923c-fb736d382a12",
  "type": "Microsoft.Authorization/policyDefinitions",
  "name": "06a78e20-9358-41c9-923c-fb736d382a12"
}