last sync: 2023-Jun-09 17:46:13 UTC

Azure Policy definition

Deploy SQL DB transparent data encryption

Name Deploy SQL DB transparent data encryption
Azure Portal
Id 86a912f6-9a06-4e26-b447-11b16ba8659f
Version 2.2.0
details on versioning
Category SQL
Microsoft docs
Description Enables transparent data encryption on SQL databases
Mode Indexed
Type BuiltIn
Preview FALSE
Deprecated FALSE
Effect Default
DeployIfNotExists
Allowed
DeployIfNotExists, Disabled
RBAC
Role(s)
Role Name Role Id
SQL DB Contributor 9b7fa17d-e63e-47b0-bb0a-15c516ac86ec
Rule
Aliases
THEN-ExistenceCondition (2)
Alias Namespace ResourceType DefaultPath Modifiable
Microsoft.Sql/servers/databases/transparentDataEncryption/state Microsoft.Sql servers/databases/transparentDataEncryption properties.state true
Microsoft.Sql/transparentDataEncryption.status Microsoft.Sql servers/databases/transparentDataEncryption properties.status false
Rule
ResourceTypes
IF (1)
Microsoft.Sql/servers/databases
THEN-Deployment (1)
Microsoft.Sql/servers/databases/transparentDataEncryption
Compliance Not a Compliance control
History
Date/Time (UTC ymd) (i) Change type Change detail
2023-01-13 18:06:06 change Minor (2.1.0 > 2.2.0)
2022-05-06 16:29:23 change Minor (2.0.0 > 2.1.0)
2021-07-16 14:58:38 change Major (1.0.0 > 2.0.0)
Initiatives
usage
Initiative DisplayName Initiative Id Initiative Category State Type
Deploy SQL Database built-in SQL security configuration Deploy-Sql-Security SQL GA ALZ
JSON