Snowflake
COF-R02 · Question #251
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. See the full explanation below for the reasoning.
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
(48 responses)- A10% (5)
- B79% (38)
- C4% (2)
- D6% (3)
Community Discussion
No community discussion yet for this question.