SOL-C01 · Question #316
What is the purpose of using the SHOW GRANTS ON SQL command for a specific object?
The correct answer is C. To list all privileges granted on the object. SHOW GRANTS ON <object_type> <object_name> returns a result set showing every privilege that has been granted on that specific object, along with the grantee (role or user) and the grantor. This is essential for auditing access control and verifying that permissions are configure
Question
What is the purpose of using the SHOW GRANTS ON SQL command for a specific object?
Options
- ATo list all users in the account
- BTo list all roles in the account
- CTo list all privileges granted on the object
- DTo list all databases that have access to the object
How the community answered
(26 responses)- A4% (1)
- C92% (24)
- D4% (1)
Explanation
SHOW GRANTS ON <object_type> <object_name> returns a result set showing every privilege that has been granted on that specific object, along with the grantee (role or user) and the grantor. This is essential for auditing access control and verifying that permissions are configured correctly. It does not list all users in the account (A) - use SHOW USERS for that - nor all roles (B) - use SHOW ROLES - nor databases with access (D), which is not a native Snowflake command.
Topics
Community Discussion
No community discussion yet for this question.