blockstorage_block_volume_backup_enabledblockstorage_block_volume_encryption_enabledblockstorage_boot_volume_backup_encryption_enabledblockstorage_boot_volume_encryption_enabledcloudguard_enabledcompute_instance_boot_volume_encryption_in_transit_enabledcompute_instance_metadata_service_disabledcompute_instance_monitoring_enableddatabase_db_encryption_enableddatabase_db_home_encryption_enableddatabase_db_system_encryption_enabledfile_storage_file_system_encryption_enabledidentity_authentication_password_policy_contains_lowercase_charactersidentity_authentication_password_policy_contains_numeric_charactersidentity_authentication_password_policy_contains_special_charactersidentity_authentication_password_policy_contains_uppercase_charactersidentity_authentication_password_policy_strong_min_length_14objectstorage_bucket_encryption_enabledobjectstorage_bucket_object_events_enabledobjectstorage_bucket_public_access_blockedobjectstorage_bucket_versioning_enabledvcn_default_security_group_allow_icmp_onlyvcn_has_inbound_security_list_configuredvcn_inbound_security_lists_are_statelessvcn_network_security_group_restrict_ingress_rdp_allvcn_network_security_group_restrict_ingress_ssh_allvcn_security_group_has_stateless_ingress_security_rulesvcn_security_list_restrict_ingress_rdp_allvcn_security_list_restrict_ingress_ssh_allvcn_subnet_public_access_blocked
Query: identity_authentication_password_policy_contains_special_characters
Usage
powerpipe query terraform_oci_compliance.query.identity_authentication_password_policy_contains_special_characters
Steampipe Tables
SQL
select address as resource, case when (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' ->> 'is_special_characters_required')::boolean then ' contains special characters' else ' does not contain special characters' end || '.' reason , path || ':' || start_linefrom terraform_resourcewhere type = 'oci_identity_authentication_policy';
Controls
The query is being used by the following controls: