Which command lists all privileges granted to a role?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

Which command lists all privileges granted to a role?

Explanation:
The command to see what a role has been granted is shown by requesting the privileges that were granted to that role. In Snowflake, you use SHOW GRANTS TO ROLE <role> to display all privileges assigned to the role, such as object privileges (SELECT on a table, USAGE on a schema) and any system privileges. This form directly targets the role as the recipient of grants, which is why it lists everything the role can do. The other phrasings don’t match Snowflake’s syntax for this query, so they wouldn’t reliably return the desired list of privileges.

The command to see what a role has been granted is shown by requesting the privileges that were granted to that role. In Snowflake, you use SHOW GRANTS TO ROLE to display all privileges assigned to the role, such as object privileges (SELECT on a table, USAGE on a schema) and any system privileges. This form directly targets the role as the recipient of grants, which is why it lists everything the role can do. The other phrasings don’t match Snowflake’s syntax for this query, so they wouldn’t reliably return the desired list of privileges.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy