Control: 9.3.4 Ensure that the Expiration Date is set for all Secrets in Non-RBAC Key Vaults
Description
Ensure that all Secrets in Non 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
- Go to 
Key vaults. - For each Key vault, click on 
Secrets. - In the main pane, ensure that the status of the secret is 
Enabled. - Set an appropriate 
Expiration dateon all secrets. 
From Azure CLI
Update the Expiration date for the secret using the below command:
az keyvault secret set-attributes --name <secret_name> --vault-name <vault_name> --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 Secret permission is required.
To update the expiration date for the secrets:
- Go to Key vault, click on 
Access policies. - Click on 
Createand add an access policy with theUpdatepermission (in the Secret Permissions - Secret Management Operations section). 
From PowerShell
For each Key vault with the EnableRbacAuthorization setting set to False or empty, run the following command.
Set-AzKeyVaultSecret -VaultName <vault_name> -Name <secret_name> -Expires <date_time>
Default Value
By default, secrets do not expire.
Usage
Run the control in your terminal:
powerpipe control run azure_compliance.control.cis_v400_9_3_4Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run azure_compliance.control.cis_v400_9_3_4 --shareSQL
This control uses a named query:
with non_rbac_vault as (  select    name  from    azure_key_vault  where not 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 ' 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 subscriptionfrom  azure_key_vault_secret kvs  left join non_rbac_vault as v on v.name = kvs.vault_name  left join azure_subscription as sub on sub.subscription_id = kvs.subscription_id;