Exam SnowPro Core topic 1 question 367 discussion

A https://docs.snowflake.com/en/sql-reference/sql/show-grants.html#variants

A. show grants to user USER1;

A is correct I just tested in my account , command result with TO give info about all role granted to user

SHOW GRANTS ON ... ACCOUNT Lists all the account-level (i.e. global) privileges that have been granted to roles. object_type object_name Lists all privileges that have been granted on the object. ------------------------------------------------------------------ SHOW GRANTS TO ... ROLE role_name Lists all privileges and roles granted to the role. USER user_name Lists all the roles granted to the user. Note that the PUBLIC role, which is automatically available to every user, is not listed.

https://docs.snowflake.com/en/sql-reference/sql/show-grants.html#variants SHOW GRANTS TO ROLE role_name Lists all privileges and roles granted to the role.

D is right