Control: 8.3 Ensure that the Expiration Date is set for all Secrets in RBAC Key Vaults

Description

It is recommended that all Secrets in the Azure Key Vault have an expiration time set. The Azure Key Vault enables users to store and keep secrets within the Microsoft Azure environment. Secrets in the Azure Key Vault are octet sequences with a maximum size of 25k bytes each. The exp (expiration time) attribute identifies the expiration time on or after which the secret MUST NOT be used.

As default, secrets never expire. It is thus recommended to rotate secrets in the key vault and set an explicit expiration time for all secrets.

Remediation

From Console

Login and go to Key vaults.
For each Key vault, go to Settings section and click on Secrets.
Make sure Status is Enabled.
Set an appropriate Expiration Date on all secrets.

From Command Line

Command to update the Expiration Date for the secret

az keyvault secret set-attributes --name <secretName> --vault-name <vaultName> --expires Y-m-d'T'H:M:S'Z'

Usage

Run the control in your terminal:

powerpipe control run azure_compliance.control.cis_v140_8_3

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run azure_compliance.control.cis_v140_8_3 --share

SQL

This control uses a named query:

with rbac_vault as (
  select
    name
  from
    azure_key_vault
  where enable_rbac_authorization
)
select
  kvs.id as resource,
  case
    when v.name is null then 'skip'
    when enabled and expires_at is null then 'alarm'
    else 'ok'
  end as status,
  vault_name || ' key ' || kvs.name ||
  case
    when v.name is null then ' not RBAC enabled vault.'
    when enabled and expires_at is null then ' expiration date not set.'
    when not enabled then ' disabled.'
    else ' expiration date set to ' || to_char(expires_at, 'DD-Mon-YYYY') || '.'
  end as reason
  
  , kvs.resource_group as resource_group
  , sub.display_name as subscription
from
  azure_key_vault_secret kvs
  left join rbac_vault as v on v.name = kvs.vault_name,
  azure_subscription sub
where
  sub.subscription_id = kvs.subscription_id;