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;

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

Latest COF-C02 Dumps Valid Version with 254 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments