Query: Default to Microsoft Entra authorization should be enabled for storage accounts

Description

Enable default Microsoft Entra (Azure AD) authorization for storage accounts to improve identity and access management.

Query

Tables used in this query:

• azure_storage_account
• azure_subscription

Controls using this query:

• 10.3.3.1 Ensure that 'Default to Microsoft Entra authorization in the Azure portal' is set to 'Enabled'
• Default to Microsoft Entra authorization should be enabled for storage accounts

SQL