Control: IAM password policy should contain at least one numeric character

Description

This control checks whether the IAM password policy contains at least one numeric character.

Usage

Run the control in your terminal:

powerpipe control run terraform_oci_compliance.control.identity_authentication_password_policy_contains_numeric_characters

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run terraform_oci_compliance.control.identity_authentication_password_policy_contains_numeric_characters --share

SQL

This control uses a named query:

select
  address as resource,
  case
    when (attributes_std -> 'password_policy' ->> 'is_numeric_characters_required')::boolean then 'ok'
    else 'alarm'
  end as status,
  split_part(address, '.', 2) || case
    when (attributes_std -> 'password_policy' ->> 'is_numeric_characters_required')::boolean then ' contains numeric characters'
    else ' does not contain numeric characters'
  end || '.' reason
  , path || ':' || start_line
from
  terraform_resource
where
  type = 'oci_identity_authentication_policy';

Control: IAM password policy should contain at least one numeric character

Description

Usage

SQL

Tags