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

Snowflake Account and Security

Question

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)

A
4% (1)
C
92% (24)
D
4% (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

#SHOW GRANTS#Permissions#SQL commands#Security

Community Discussion

No community discussion yet for this question.

Full SOL-C01 Practice