| Json |
{
"properties": {
"displayName": "Auditing on SQL server should be enabled",
"policyType": "BuiltIn",
"mode": "Indexed",
"description": "Auditing on your SQL Server should be enabled to track database activities across all databases on the server, except Synapse, and save them in an audit log.",
"metadata": {
"version": "2.0.0",
"category": "SQL"
},
"parameters": {
"effect": {
"type": "String",
"metadata": {
"displayName": "Effect",
"description": "Enable or disable the execution of the policy"
},
"allowedValues": [
"AuditIfNotExists",
"Disabled"
],
"defaultValue": "AuditIfNotExists"
},
"setting": {
"type": "String",
"metadata": {
"displayName": "Desired Auditing setting"
},
"allowedValues": [
"enabled",
"disabled"
],
"defaultValue": "enabled"
}
},
"policyRule": {
"if": {
"allOf": [
{
"field": "type",
"equals": "Microsoft.Sql/servers"
},
{
"field": "kind",
"notContains": "analytics"
}
]
},
"then": {
"effect": "[parameters('effect')]",
"details": {
"type": "Microsoft.Sql/servers/auditingSettings",
"name": "default",
"existenceCondition": {
"field": "Microsoft.Sql/auditingSettings.state",
"equals": "[parameters('setting')]"
}
}
}
}
},
"id": "/providers/Microsoft.Authorization/policyDefinitions/a6fb4358-5bf4-4ad7-ba82-2cd2f41ce5e9",
"type": "Microsoft.Authorization/policyDefinitions",
"name": "a6fb4358-5bf4-4ad7-ba82-2cd2f41ce5e9"
}
|