Query: Shared key access should be disabled for storage accounts

Description

Disabling shared key access ensures that only Azure AD identities can access storage accounts, improving security.

Query

Tables used in this query:

• azure_storage_account
• azure_subscription

Controls using this query:

• 10.3.1.3 Ensure 'Allow storage account key access' for Azure Storage Accounts is 'Disabled'
• 9.3.1.3 Ensure 'Allow storage account key access' for Azure Storage Accounts is 'Disabled'
• Shared key access should be disabled for storage accounts

SQL