iam_schema_managed_access_enablediam_user_at_least_two_users_with_accountadmin_roleiam_user_default_role_is_setiam_user_default_role_must_not_be_accountadminiam_user_with_accountadmin_role_have_emailiam_user_with_built_in_duo_mfa_enablediam_user_without_accountadmin_role_password_not_setmanual_controlmonitoring_user_password_rotated_regularlynetwork_policy_allowed_list_setnetwork_policy_blocked_list_set
Query: manual_control
Usage
steampipe query snowflake_compliance.query.manual_controlPlugins & Tables
SQL
select -- Required Columns account as resource, 'info' as status, 'Manual verification required.' as reason, -- Additional Dimensions accountfrom snowflake_userlimit 1;Controls
The query is being used by the following controls:
- security_overview_data_encryption_automatic_cmk_rotation
- security_overview_data_encryption_enable_periodic_rekeying
- security_overview_data_encryption_tri_secret_secure_in_database_replication
- security_overview_data_encryption_use_built_in_encryption_functions
- security_overview_data_encryption_use_tri_secret_secure
- security_overview_network_security_add_snowflake_ip_policy_firewall_rules
- security_overview_network_security_allow_firewall_to_connect_client_applications
- security_overview_network_security_use_private_connectivity