SnowPro Core Certification — Question 223

Which SQL command can be used to verify the privileges that are granted to a role?

Answer options

• A. SHOW GRANTS ON ROLE [Role Name]
• B. SHOW ROLES [Role Name]
• C. SHOW GRANTS TO ROLE [Role Name]
• D. SHOW GRANTS FOR ROLE [Role Name]

Correct answer: C

Explanation

The correct command is 'SHOW GRANTS TO ROLE [Role Name]', as it explicitly lists the privileges associated with the specified role. The other options either refer to incorrect syntax or do not serve the purpose of displaying granted privileges.