last sync: 2024-Oct-11 17:51:27 UTC

Deploy SQL database auditing settings

Azure Landing Zones (ALZ) Policy definition

Source Repository Azure Landing Zones (ALZ) GitHub
JSON Deploy-Sql-AuditingSettings
Deploy policy Deploy-Sql-AuditingSettings (1.0.0) to Azure
Display name Deploy SQL database auditing settings
Id Deploy-Sql-AuditingSettings
Version 1.0.0
Details on versioning
Category SQL
Description Deploy auditing settings to SQL Database when it not exist in the deployment
Mode Indexed
Type Custom Azure Landing Zones (ALZ)
Preview False
Deprecated False
Effect Default
DeployIfNotExists
Allowed
DeployIfNotExists, Disabled
RBAC role(s)
Role Name Role Id
SQL Security Manager 056cd41c-7e88-42e1-933e-88ba6a50c9c3
Rule aliases THEN-ExistenceCondition (2)
Alias Namespace ResourceType Path PathIsDefault DefaultPath Modifiable
Microsoft.Sql/servers/databases/auditingSettings/isAzureMonitorTargetEnabled Microsoft.Sql servers/databases/auditingSettings properties.isAzureMonitorTargetEnabled True False
Microsoft.Sql/servers/databases/auditingSettings/state Microsoft.Sql servers/databases/auditingSettings properties.state True True
Rule resource types IF (1)
Microsoft.Sql/servers/databases
THEN-Deployment (1)
Microsoft.Sql/servers/databases/auditingSettings
Initiatives usage
Initiative DisplayName Initiative Id Initiative Category State
[Deprecated]: Deploy SQL Database built-in SQL security configuration Deploy-Sql-Security SQL Deprecated
Deploy SQL Database built-in SQL security configuration Deploy-Sql-Security_20240529 SQL GA
History none
JSON compare n/a
JSON
EPAC
Deploy policy Deploy-Sql-AuditingSettings (1.0.0) to Azure