turbot/snowflake_compliance

Query: iam_user_default_role_is_set

Usage

powerpipe query snowflake_compliance.query.iam_user_default_role_is_set

Steampipe Tables

SQL

select
name as resource,
case when default_role = '' then
'alarm'
else
'ok'
end as status,
case when default_role = '' then
name || ' default_role is not set.'
else
name || ' default_role is set.'
end as reason,
account
from
snowflake_user;

Controls

The query is being used by the following controls: