
Explanation:
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.
Which Snowflake SQL command is used to identify the users and roles that have been granted a specific role named MY_ROLE?
A
SHOW GRANTS OF ROLE MY_ROLE
B
SHOW GRANTS TO ROLE MY_ROLE
C
SHOW GRANTS FOR ROLE MY_ROLE
D
SHOW GRANTS ON ROLE MY_ROLE
No comments yet.