turbot/terraform_oci_compliance

Query: identity_authentication_password_policy_strong_min_length_14

Usage

powerpipe query terraform_oci_compliance.query.identity_authentication_password_policy_strong_min_length_14

Steampipe Tables

SQL

select
address as resource,
case
when (
attributes_std -> 'password_policy' ->> 'minimum_password_length'
) is not null
and (
attributes_std -> 'password_policy' ->> 'minimum_password_length'
) :: integer >= 14
and (
(
attributes_std -> 'password_policy' ->> 'is_numeric_characters_required'
) :: boolean
or (
attributes_std -> 'password_policy' ->> 'is_special_characters_required'
) :: boolean
) then 'ok'
else 'alarm'
end as status,
split_part(address, '.', 2) || case
when (
attributes_std -> 'password_policy' ->> 'minimum_password_length'
) is null then ' No password policy set'
when (
attributes_std -> 'password_policy' ->> 'minimum_password_length'
) :: integer >= 14
and (
(
attributes_std -> 'password_policy' ->> 'is_numeric_characters_required'
) :: boolean
or (
attributes_std -> 'password_policy' ->> 'is_special_characters_required'
) :: boolean
) then ' Strong password policies configured'
else ' Strong password policies not configured'
end || '.' reason,
path || ':' || start_line
from
terraform_resource
where
type = 'oci_identity_authentication_policy';

Controls

The query is being used by the following controls: