Which SQL command can be used to verify the privileges that are granted to a role?
A.
SHOW GRANTS ON ROLE
B.
SHOW ROLES
C.
SHOW GRANTS TO ROLE
D.
SHOW GRANTS FOR ROLE
The Answer Is:
C
This question includes an explanation.
Explanation:
To verify the privileges that have been granted to a specific role in Snowflake, the correct SQL command isSHOW GRANTS TO ROLE <Role Name>. This command lists all the privileges granted to the specified role, including access to schemas, tables, and other database objects. This is a useful command for administrators and users with sufficient privileges to audit and manage role permissions within the Snowflake environment.
[References:, Snowflake Documentation: SHOW GRANTS, ]
COF-C02 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"