SnowPro Core Certification — Question 169

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

Answer options

• 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

Correct answer: A

Explanation

The correct answer is A, as the command SHOW GRANTS OF ROLE MY_ROLE specifically lists all users and roles that have been granted the role MY_ROLE. The other options are incorrect because they either imply a direction or context that doesn't match the requirement of identifying who has access to the role.