Answer: SHOW GRANTS OF ROLE MY_ROLE

The question asks to determine which users and roles have access to a role called MY_ROLE, meaning we need to find who has been granted this role. According to Snowflake documentation and the community discussion consensus (with the highest upvoted comments supporting A), SHOW GRANTS OF ROLE MY_ROLE lists all users and roles to which the role has been granted. Option B (SHOW GRANTS TO ROLE) shows privileges granted to the role, not who has been granted the role. Options C and D use incorrect syntax (FOR and ON) that are not valid for this purpose in Snowflake SQL.

Author: LeetQuiz Editorial Team