turbot/snowflake_compliance

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:

powerpipe control run snowflake_compliance.control.security_overview_iam_user_with_accountadmin_role_have_email

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run snowflake_compliance.control.security_overview_iam_user_with_accountadmin_role_have_email --share

SQL

This control uses a named query:

iam_user_with_accountadmin_role_have_email