last sync: 2021-Jan-22 16:07:27 UTC

Azure Policy definition

[Deprecated]: Advanced Threat Protection types should be set to 'All' in SQL server Advanced Data Security settings

Name [Deprecated]: Advanced Threat Protection types should be set to 'All' in SQL server Advanced Data Security settings
Azure Portal
Id e756b945-1b1b-480b-8de8-9a0859d5f7ad
Version 1.0.0-deprecated
details on versioning
Category SQL
Microsoft docs
Description It is recommended to enable all Advanced Threat Protection types on your SQL servers. Enabling all types protects against SQL injection, database vulnerabilities, and any other anomalous activities.
Mode Indexed
Type BuiltIn
Preview FALSE
Deprecated True
Effect Default: Disabled
Allowed: (AuditIfNotExists, Disabled)
Used RBAC Role none
History
Date/Time (UTC ymd) (i) Change type Change detail
2020-07-01 14:50:07 change Previous DisplayName: Advanced Threat Protection types should be set to 'All' in SQL server Advanced Data Security settings
Used in Initiatives none
Json
{
  "properties": {
  "displayName": "[Deprecated]: Advanced Threat Protection types should be set to 'All' in SQL server Advanced Data Security settings",
    "policyType": "BuiltIn",
    "mode": "Indexed",
    "description": "It is recommended to enable all Advanced Threat Protection types on your SQL servers. Enabling all types protects against SQL injection, database vulnerabilities, and any other anomalous activities.",
    "metadata": {
      "version": "1.0.0-deprecated",
      "category": "SQL",
      "deprecated": true
    },
    "parameters": {
      "effect": {
        "type": "String",
        "metadata": {
        "displayName": "[Deprecated]: Effect",
          "description": "Enable or disable the execution of the policy"
        },
        "allowedValues": [
          "AuditIfNotExists",
          "Disabled"
        ],
        "defaultValue": "Disabled"
      }
    },
    "policyRule": {
      "if": {
        "field": "type",
        "equals": "Microsoft.Sql/servers"
      },
      "then": {
      "effect": "[parameters('effect')]",
        "details": {
          "type": "Microsoft.Sql/servers/securityAlertPolicies",
          "name": "default",
          "existenceCondition": {
          "field": "Microsoft.Sql/servers/securityAlertPolicies/disabledAlerts[*]",
            "equals": ""
          }
        }
      }
    }
  },
  "id": "/providers/Microsoft.Authorization/policyDefinitions/e756b945-1b1b-480b-8de8-9a0859d5f7ad",
  "type": "Microsoft.Authorization/policyDefinitions",
  "name": "e756b945-1b1b-480b-8de8-9a0859d5f7ad"
}