Mods

turbot/snowflake_compliance

GitHub
Overview
1Dashboards
18Controls
11Queries
3Variables
GitHub
Loading controls...
On This Page
Description
Usage
SQL
Get Involved
Edit on GitHub
Discuss on Slack

Control: Set the default_role property for users

Description

A user's default role determines the role used in the Snowflake sessions initiated by the user; however, this is only a default. Users can change roles within a session at any time. Snowflake recommends that designate a lower-level administrative or custom role as their default.

Usage

Run the control in your terminal:

steampipe check snowflake_compliance.control.security_overview_iam_user_default_role_is_set

Snapshot and share results via Steampipe Cloud:

steampipe login
steampipe check --share snowflake_compliance.control.security_overview_iam_user_default_role_is_set

SQL

This control uses a named query:

iam_user_default_role_is_set