Query: identity_authentication_password_policy_strong_min_length_14

select
  tenant_id as resource,
  case
    when
      minimum_password_length >= 14
      and (is_numeric_characters_required or is_special_characters_required)
    then 'ok'
    else 'alarm'
  end as status,
  case
    when minimum_password_length is null then 'No password policy set.'
    when
      minimum_password_length >= 14
      and (is_numeric_characters_required or is_special_characters_required)
    then 'Strong password policies configured.'
    else 'Strong password policies not configured.'
  end as reason
  , tenant_name as tenant
from
  oci_identity_authentication_policy;