Exam SnowPro Core topic 1 question 234 discussion

A: SHOW GRANTS OF ROLE shows who as been granted (Correct) B: SHOW GRANTS TO ROLE show privileges granted https://docs.snowflake.com/en/sql-reference/sql/show-grants.html

A: SHOW GRANTS OF ROLE this option shows which users and roles have access to a role, while, B: SHOW GRANTS TO ROLE this option only shows which roles have access to a role, is doesn't specify the user.

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;

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 | +---------------------------------+------------------+------------+------------+------------+--------------+------------+

Answer is B SHOW GRANTS TO ROLE <role_name>;

OF is correct.

correct

SHOW GRANTS TO ROLE //Is the correct one else One can check on worksheet.

Ans is A

https://docs.snowflake.com/en/sql-reference/sql/show-grants#examples

https://docs.snowflake.com/en/sql-reference/sql/show-grants#:~:text=to%20the%20share.-,SHOW%20GRANTS%20OF,-...

A is correct.

Answer is A SHOW GRANTS OF... ROLE role_name Lists all users and roles to which the role has been granted.

MY_ROLE doesn't have access to users and roles. It is the other way round - Users and roles were given access to MY_ROLE so SHOW GRANTS OF ROLE MY_ROLE.

Answer is A. SHOW OF ROLE and SHOW TO ROLE has different outputs.

It could A or B Syntax SHOW GRANTS SHOW GRANTS ON ACCOUNT SHOW GRANTS ON <object_type> <object_name> SHOW GRANTS TO { ROLE <role_name> | USER <user_name> | SHARE <share_name> } SHOW GRANTS OF ROLE <role_name> SHOW GRANTS OF SHARE <share_name> SHOW FUTURE GRANTS IN SCHEMA { <schema_name> } SHOW FUTURE GRANTS IN DATABASE { <database_name> } SHOW FUTURE GRANTS TO ROLE <role_name> https://docs.snowflake.com/en/sql-reference/sql/show-grants.html

https://docs.snowflake.com/en/sql-reference/sql/show-grants.html