Query: Ensure that 'Public access level' is set to Private for blob containers

Description

Disable anonymous access to blob containers and disallow blob public access on storage account.

Query

Tables used in this query:

• azure_storage_account
• azure_storage_container
• azure_subscription

Controls using this query:

• 3.17 Ensure that `Allow Blob Anonymous Access` is set to `Disabled`
• 3.5 Ensure that 'Public access level' is set to Private for blob containers
• 3.5 Ensure that 'Public access level' is set to Private for blob containers
• 3.7 Ensure that 'Public access level' is disabled for storage accounts with blob containers
• 3.7 Ensure that 'Public access level' is disabled for storage accounts with blob containers
• 4.17 Ensure that `Allow Blob Anonymous Access` is set to `Disabled`
• Ensure that 'Public access level' is set to Private for blob containers

SQL