Which command will you run to list all privileges and roles granted to the role

Which command will you run to list all privileges and roles granted to the role
A . SHOW GRANTS TO ROLE <ROLE NAME>
B. SHOW GRANTS ON ROLE <ROLE NAME>
C. SHOW GRANTS OF ROLE <ROLE NAME>
D. SHOW GRANTS FOR ROLE <ROLE NAME>

View Answer

Answer: A

Explanation:

Variants

SHOW GRANTS ON …

ACCOUNT

Lists all the account-level (i.e. global) privileges that have been granted to roles.

object_type object_name

Lists all privileges that have been granted on the object.

SHOW GRANTS TO …

ROLE role_name

Lists all privileges and roles granted to the role.

USER user_name

Lists all the roles granted to the user.

SHARE share_name

Lists all the privileges granted to the share.

SHOW GRANTS OF…

ROLE role_name

Lists all users and roles to which the role has been granted.

SHARE share_name

Lists all the accounts for the share and indicates the accounts that are using the share.

SHOW FUTURE GRANTS IN …

SCHEMA database_name.schema_name

Lists all privileges on new (i.e. future) objects of a specified type in the schema granted to a role.

database_name. specifies the database in which the schema resides and is optional when querying a

schema in the current database.

DATABASE database_name

Lists all privileges on new (i.e. future) objects of a specified type in the database granted to a role. Please also go through this link thoroughly. These requires mugging up and no concepts https://docs.snowflake.com/en/sql-reference/sql/show-grants.html#show-grants