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>
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
Latest ARA-C01 Dumps Valid Version with 156 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund