Control: Cosmos DB accounts should have access key metadata writes disabled

Description

Disable access key metadata writes on your Azure Cosmos DB accounts to prevent the access key from being overwritten. This prevents the access key from being overwritten by a user or application.

Usage

Run the control in your terminal:

powerpipe control run terraform_azure_compliance.control.cosmodb_account_access_key_metadata_writes_disabled

Snapshot and share results via Turbot Pipes:

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

SQL

This control uses a named query:

select
  address as resource,
  case
    when (attributes_std ->> 'access_key_metadata_writes_enabled') is null then 'alarm'
    when (attributes_std ->> 'access_key_metadata_writes_enabled')::boolean then 'alarm'
    else 'ok'
  end status,
  split_part(address, '.', 2) || case
    when (attributes_std ->> 'access_key_metadata_writes_enabled') is null then ' access key metadata writes enabled'
    when (attributes_std ->> 'access_key_metadata_writes_enabled')::boolean then  ' access key metadata writes enabled'
    else ' access key metadata writes disabled'
  end || '.' reason
  
  , path || ':' || start_line
from
  terraform_resource
where
  type = 'azurerm_cosmosdb_account';

Control: Cosmos DB accounts should have access key metadata writes disabled

Description

Usage

SQL

Tags