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;
The Answer Is:
A
This question includes an explanation.
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. References: SHOW GRANTS | Snowflake Documentation
COF-C03 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"