If a user is granted ROLE-A, which roles can they switch to in the Snowflake UI?

Master Snowflake Data Engineer Exam. Study with flashcards and multiple choice questions, each question includes hints and explanations. Prepare for your success!

Multiple Choice

If a user is granted ROLE-A, which roles can they switch to in the Snowflake UI?

Explanation:
In Snowflake, you can switch to any role you have been granted access to, specifically the roles for which you have the USAGE privilege, either directly or through a role you already hold. If a user is granted ROLE-A and the environment also grants them access to ROLE-B, ROLE-C, ROLE-D, and ROLE-E (through direct grants or via role inheritance), they can switch to all of those roles from the UI. SYSADMIN is a separate high-privilege role, and you only gain access to it if you are explicitly granted it (or have a path granting USAGE on it). Since the scenario only states a grant to ROLE-A, the user can switch to ROLE-A through ROLE-E, but not necessarily SYSADMIN.

In Snowflake, you can switch to any role you have been granted access to, specifically the roles for which you have the USAGE privilege, either directly or through a role you already hold. If a user is granted ROLE-A and the environment also grants them access to ROLE-B, ROLE-C, ROLE-D, and ROLE-E (through direct grants or via role inheritance), they can switch to all of those roles from the UI. SYSADMIN is a separate high-privilege role, and you only gain access to it if you are explicitly granted it (or have a path granting USAGE on it). Since the scenario only states a grant to ROLE-A, the user can switch to ROLE-A through ROLE-E, but not necessarily SYSADMIN.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy