What is the SHOW GRANTS SQL command primarily used for?
To view the history of data loads.
To display all privileges granted to a role or user.
To list all active users in the account.
To show current warehouse credit usage.
SHOW GRANTS lists privileges assigned to roles, users, objects, or shares. It is essential for permissions auditing and RBAC management.
SHOW USERS lists users, not privileges.
Warehouse usage is in ACCOUNT_USAGE views.
Load history is retrieved via COPY_HISTORY or LOAD_HISTORY.
====================================================
Submit