last sync: 2023-Dec-05 19:46:27 UTC

Azure Policy definition

Azure SQL Database should have Microsoft Entra-only authentication enabled

Source Azure Portal
Display name Azure SQL Database should have Microsoft Entra-only authentication enabled
Id abda6d70-9778-44e7-84a8-06713e6db027
Version 1.1.0
Details on versioning
Category SQL
Microsoft Learn
Description Disabling local authentication methods and allowing only Microsoft Entra authentication improves security by ensuring that Azure SQL Databases can exclusively be accessed by Microsoft Entra identities. Learn more at:
Mode Indexed
Type BuiltIn
Preview False
Deprecated False
Effect Default
Audit, Deny, Disabled
RBAC role(s) none
Rule aliases IF (2)
Alias Namespace ResourceType DefaultPath Modifiable
Microsoft.Sql/servers/administrators.azureADOnlyAuthentication Microsoft.Sql servers properties.administrators.azureADOnlyAuthentication false
Microsoft.Sql/servers/azureADOnlyAuthentications/azureADOnlyAuthentication Microsoft.Sql servers/azureADOnlyAuthentications properties.azureADOnlyAuthentication false
Rule resource types IF (2)
The following 1 compliance controls are associated with this Policy definition 'Azure SQL Database should have Microsoft Entra-only authentication enabled' (abda6d70-9778-44e7-84a8-06713e6db027)
Control Domain Control Name MetadataId Category Title Owner Requirements Description Info Policy#
Azure_Security_Benchmark_v3.0 DP-4 Azure_Security_Benchmark_v3.0_DP-4 Microsoft cloud security benchmark DP-4 Data Protection Enable data at rest encryption by default Shared **Security Principle:** To complement access controls, data at rest should be protected against 'out of band' attacks (such as accessing underlying storage) using encryption. This helps ensure that attackers cannot easily read or modify the data. **Azure Guidance:** Many Azure services have data at rest encryption enabled by default at the infrastructure layer using a service-managed key. Where technically feasible and not enabled by default, you can enable data at rest encryption in the Azure services, or in your VMs for storage level, file level, or database level encryption. **Implementation and additional context:** Understand encryption at rest in Azure: Data at rest double encryption in Azure: Encryption model and key management table: n/a link 13
Initiatives usage
Initiative DisplayName Initiative Id Initiative Category State Type
Microsoft cloud security benchmark 1f3afdf9-d0c9-4c3d-847f-89da613e70a8 Security Center GA BuiltIn
Date/Time (UTC ymd) (i) Change type Change detail
2023-10-31 19:02:40 change Minor (1.0.0 > 1.1.0)
2021-08-13 17:07:49 add abda6d70-9778-44e7-84a8-06713e6db027
JSON compare
compare mode: version left: version right: