Control: Storage container public access should be disabled

Description

This control checks whether the public access level is set to private for the storage container.

Usage

Run the control in your terminal:

powerpipe control run terraform_azure_compliance.control.storage_container_restrict_public_access

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run terraform_azure_compliance.control.storage_container_restrict_public_access --share

SQL

This control uses a named query:

select
  address as resource,
  case
    when (attributes_std ->> 'container_access_type') = 'private' or (attributes_std ->> 'container_access_type') is null then 'ok'
    else 'alarm'
  end status,
  split_part(address, '.', 2) || case
    when (attributes_std ->> 'container_access_type') = 'private' or (attributes_std ->> 'container_access_type') is null then ' not publicly accessible'
    else ' publicly accessible'
  end || '.' reason
  
  , path || ':' || start_line
from
  terraform_resource
where
  type = 'azurerm_storage_container';