AzPolicyAdvertizer

last sync: 2024-Jul-26 18:17:39 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
Category SQL
Microsoft Learn
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 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)
Microsoft.Sql/servers/databases
THEN-Deployment (1)
Microsoft.Sql/servers/databases/transparentDataEncryption
Compliance Not a Compliance control
Initiatives usage
Initiative DisplayName Initiative Id Initiative Category State Type
[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
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