COF-C02 Question 298

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A2

  A is the answer.. List all roles and users who have been granted the analyst role: SHOW GRANTS OF ROLE analyst; List all privileges granted to the analyst role: SHOW GRANTS TO ROLE analyst;

• Chose B3

  List all privileges granted to the ROLE role: https://docs.snowflake.com/en/sql-reference/sql/show-grants SHOW GRANTS TO ROLE analyst; +---------------------------------+------------------+------------+------------+------------+--------------+------------+ | created_on | privilege | granted_on | name | granted_to | grant_option | granted_by | |---------------------------------+------------------+------------+------------+------------+--------------+------------+ | Wed, 17 Dec 2014 18:19:37 -0800 | CREATE WAREHOUSE | ACCOUNT | DEMOENV | ANALYST | false | SYSADMIN | +---------------------------------+------------------+------------+------------+------------+--------------+------------+

• 1

  Answer is B SHOW GRANTS TO ROLE <role_name>;