last sync: 2021-Jan-18 16:05:48 UTC

Azure Policy definition

[Deprecated]: Audit SQL DB Level Audit Setting

Name [Deprecated]: Audit SQL DB Level Audit Setting
Azure Portal
Id 06a78e20-9358-41c9-923c-fb736d382a12
Version 1.0.0-deprecated
details on versioning
Category SQL
Microsoft docs
Description Audit DB level audit setting for SQL databases
Mode All
Type BuiltIn
Preview FALSE
Deprecated True
Effect Fixed: AuditIfNotExists
Used RBAC Role none
History
Date/Time (UTC ymd) (i) Change type Change detail
2019-10-08 15:55:12 change Previous DisplayName: Audit SQL DB Level Audit Setting
Used in Initiatives none
Json
{
  "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"
}