Answer-first summary for fast verification
Answer: show grants to user USER1;
The question asks for the SQL command to view all roles granted to USER1. Option A 'show grants to user USER1;' is the correct Snowflake command for this purpose, as confirmed by the official documentation link provided in the community discussion and multiple users who tested it. The documentation states that 'SHOW GRANTS TO USER user_name' lists all roles granted to the user. Option D 'show grants on user USER1;' is incorrect because 'SHOW GRANTS ON' is used for viewing privileges on objects, not roles granted to users. Options B and C are syntactically incorrect or serve different purposes. The community consensus strongly favors A (77% support) with upvoted comments referencing official documentation, while D has minimal support (23%) and is based on a misunderstanding of the syntax.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
