
Answer-first summary for fast verification
Answer: SHOW GRANTS TO ROLE [Role Name]
The correct answer is C: SHOW GRANTS TO ROLE [Role Name]. This command specifically lists all privileges and roles granted to a particular role, which directly addresses the question's requirement to verify privileges granted to a role. The community discussion shows 100% consensus on option C, with multiple users citing the official Snowflake documentation that confirms SHOW GRANTS TO ROLE is the proper syntax. Option A (SHOW GRANTS ON ROLE) is incorrect as it would show grants on the role object itself, not privileges granted to the role. Option B (SHOW ROLES) shows available roles but not their privileges. Option D uses incorrect syntax with 'FOR' instead of 'TO', which is not valid in Snowflake.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.