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: