Snowflake
COF-C02 · Question #145
Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
The correct answer is B. SHOW GRANTS TO ROLE MY_ROLE. The SQL statement SHOW GRANTS TO ROLE MY_ROLE is used to determine which users and roles have access to a role called MY_ROLE. This statement lists all the privileges granted to the role, including which roles and users can assume MY_ROLE.
Account Access and Security
Question
Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
Options
- ASHOW GRANTS OF ROLE MY_ROLE
- BSHOW GRANTS TO ROLE MY_ROLE
- CSHOW GRANTS FOR ROLE MY_ROLE
- DSHOW GRANTS ON ROLE MY_ROLE
How the community answered
(35 responses)- A3% (1)
- B86% (30)
- C9% (3)
- D3% (1)
Explanation
The SQL statement SHOW GRANTS TO ROLE MY_ROLE is used to determine which users and roles have access to a role called MY_ROLE. This statement lists all the privileges granted to the role, including which roles and users can assume MY_ROLE.
Topics
#RBAC#SHOW GRANTS#Access Control#Security Auditing
Community Discussion
No community discussion yet for this question.