turbot/steampipe-mod-azure-compliance

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

Description

Ensure that all Secrets in Role Based Access Control (RBAC) Azure Key Vaults have an expiration date 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 date) attribute identifies the expiration date on or after which the secret MUST NOT be used. By default, secrets never expire. It is thus recommended to rotate secrets in the key vault and set an explicit expiration date for all secrets. This ensures that the secrets cannot be used beyond their assigned lifetimes.

Remediation

From Azure Portal

  1. Go to Key vaults.
  2. For each Key vault, click on Secrets.
  3. In the main pane, ensure that the status of the secret is Enabled.
  4. For each enabled secret, ensure that an appropriate Expiration date is set.

From Azure CLI

Update the Expiration date for the secret using the below command:

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

Note To view the expiration date on all secrets in a Key Vault using Microsoft API, the List Key permission is required.

To update the expiration date for the secrets:

  1. Go to the Key vault, click on Access Control (IAM).
  2. Click on Add role assignment and assign the role of Key Vault Secrets Officer to the appropriate user.

From Powershell

Set-AzKeyVaultSecretAttribute -VaultName <Vault Name> -Name <Secret Name> - Expires <DateTime>

Default Value

By default, secrets do not expire.

Usage

Run the control in your terminal:

powerpipe control run azure_compliance.control.cis_v210_8_3

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run azure_compliance.control.cis_v210_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;

Tags