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: Ensure an email address is specified for users with ACCOUNTADMIN role

Description

Snowflake recommendsto associate an actual person's email address to ACCOUNTADMIN users, so that Snowflake Support knows who to contact in an urgent situation.

Usage

Run the control in your terminal:

steampipe check snowflake_compliance.control.security_overview_iam_user_with_accountadmin_role_have_email

Snapshot and share results via Steampipe Cloud:

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

SQL

This control uses a named query:

iam_user_with_accountadmin_role_have_email