What SQL command would be used to view all roles that were granted to user.1?

What SQL command would be used to view all roles that were granted to user.1?
A . show grants to user USER1;
B . show grants of user USER1;
C . describe user USER1;
D . show grants on user USER1;

View Answer

Answer: A

Explanation:

The correct command to view all roles granted to a specific user in Snowflake is SHOW GRANTS TO USER <user_name>;. This command lists all access control privileges that have been explicitly granted to the specified user.

Reference: SHOW GRANTS | Snowflake Documentation