last sync: 2024-Oct-10 19:12:06 UTC

Configure Azure Defender to be enabled on SQL servers

Azure BuiltIn Policy definition

Source Azure Portal
Display name Configure Azure Defender to be enabled on SQL servers
Id 36d49e87-48c4-4f2e-beed-ba4ed02b71f5
Version 2.1.0
Details on versioning
Versioning Versions supported for Versioning: 1
2.1.0
Built-in Versioning [Preview]
Category SQL
Microsoft Learn
Description Enable Azure Defender on your Azure SQL Servers to detect anomalous activities indicating unusual and potentially harmful attempts to access or exploit databases.
Mode Indexed
Type BuiltIn
Preview False
Deprecated False
Effect Fixed
DeployIfNotExists
RBAC role(s)
Role Name Role Id
SQL Security Manager 056cd41c-7e88-42e1-933e-88ba6a50c9c3
Rule aliases THEN-ExistenceCondition (1)
Alias Namespace ResourceType Path PathIsDefault DefaultPath Modifiable
Microsoft.Sql/securityAlertPolicies.state Microsoft.Sql
Microsoft.Sql
servers/databases/securityAlertPolicies
servers/securityAlertPolicies
properties.state
properties.state
True
True

False
False
Rule resource types IF (1)
Microsoft.Sql/servers
THEN-Deployment (1)
Microsoft.Sql/servers/securityAlertPolicies
Compliance Not a Compliance control
Initiatives usage
Initiative DisplayName Initiative Id Initiative Category State Type
[Preview]: Control the use of Microsoft SQL in a Virtual Enclave 0fbe78a5-1722-4f1b-83a5-89c14151fa60 VirtualEnclaves Preview BuiltIn
[Preview]: Motion Picture Association of America (MPAA) 92646f03-e39d-47a9-9e24-58d60ef49af8 Regulatory Compliance Preview BuiltIn
Configure Azure Defender to be enabled on SQL Servers and SQL Managed Instances 9cb3cc7a-b39b-4b82-bc89-e5a5d9ff7b97 Security Center GA BuiltIn
History
Date/Time (UTC ymd) (i) Change type Change detail
2021-07-30 15:17:20 change Minor (2.0.0 > 2.1.0)
2021-01-05 16:06:49 change Major (1.1.0 > 2.0.0)
2020-10-27 14:12:45 change Minor (1.0.0 > 1.1.0)
JSON compare
compare mode: version left: version right:
JSON
api-version=2021-06-01
EPAC