Question

A Snowflake administrator creates a custom role hierarchy for an analytics team. The role DATA_ANALYST is granted to the role TEAM_LEAD, and TEAM_LEAD is granted to SYSADMIN. The DATA_ANALYST role has SELECT privileges on the SALES schema. A user is granted only the TEAM_LEAD role and uses it as their active role. Which statement correctly describes the privileges available to this user?

Accepted Answer

The user inherits the SELECT privileges on SALES because TEAM_LEAD inherits all privileges granted to DATA_ANALYST.

Answer

The user cannot access SALES because privileges only flow downward from parent roles to child roles.

Answer

The user can access SALES only after also activating DATA_ANALYST as a secondary role.

Answer

The user gains SELECT on SALES only if SYSADMIN is also granted directly to the user.