turbot/steampipe-mod-terraform-oci-compliance

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

Description

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

Usage

Run the control in your terminal:

powerpipe control run terraform_oci_compliance.control.identity_authentication_password_policy_contains_uppercase_characters

Snapshot and share results via Turbot Pipes:

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

SQL

This control uses a named query:

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

Tags