turbot/snowflake_compliance

Query: iam_user_with_built_in_duo_mfa_enabled

Usage

powerpipe query snowflake_compliance.query.iam_user_with_built_in_duo_mfa_enabled

Steampipe Tables

SQL

select
name as resource,
case
when ext_authn_duo then 'ok'
else 'alarm'
end as status,
case
when ext_authn_duo then name || ' built-in Duo MFA enabled.'
else name || ' built-in Duo MFA not enabled.'
end as reason,
account
from
snowflake_user;

Controls

The query is being used by the following controls: