AzPolicyAdvertizer

last sync: 2025-Oct-31 18:22:59 UTC

Deploy SQL DB transparent data encryption

Azure BuiltIn Policy definition

Source Azure Portal
Display name Deploy SQL DB transparent data encryption
Id 86a912f6-9a06-4e26-b447-11b16ba8659f
Version 2.2.0
Details on versioning
Versioning Versions supported for Versioning: 1
2.2.0
Built-in Versioning [Preview]
Category SQL
Microsoft Learn
Description Enables transparent data encryption on SQL databases
Cloud environments AzureCloud = true
AzureUSGovernment = true
AzureChinaCloud = unknown
Available in AzUSGov The Policy is available in AzureUSGovernment cloud. Version: '2.*.*'
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 Path PathIsDefault DefaultPath Modifiable
Microsoft.Sql/servers/databases/transparentDataEncryption/state Microsoft.Sql servers/databases/transparentDataEncryption properties.state True True
Microsoft.Sql/transparentDataEncryption.status Microsoft.Sql servers/databases/transparentDataEncryption properties.status True False
Rule resource types IF (1)
THEN-Deployment (1)
Compliance Not a Compliance control
Initiatives usage
Initiative DisplayName Initiative Id Initiative Category State Type polSet in AzUSGov
[Deprecated]: Deploy SQL Database built-in SQL security configuration Deploy-Sql-Security SQL Deprecated ALZ
[Preview]: Control the use of Microsoft SQL in a Virtual Enclave 0fbe78a5-1722-4f1b-83a5-89c14151fa60 VirtualEnclaves Preview BuiltIn true
Deploy SQL Database built-in SQL security configuration Deploy-Sql-Security_20240529 SQL GA ALZ
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)
JSON compare
compare mode: version left: version right:
JSON
api-version=2021-06-01
EPAC