Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
To identify which users and roles have access to a specific role called MY_ROLE in Snowflake, the correct SQL statement is 'SHOW GRANTS OF ROLE MY_ROLE'. This command lists all users and roles to which the specified role has been granted, providing a clear view of access privileges related to that role.
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
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 | +---------------------------------+------------------+------------+------------+------------+--------------+------------+
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.
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;
https://docs.snowflake.com/en/sql-reference/sql/show-grants#examples
Answer is A SHOW GRANTS OF... ROLE role_name Lists all users and roles to which the role has been granted.
Answer is A. SHOW OF ROLE and SHOW TO ROLE has different outputs.
https://docs.snowflake.com/en/sql-reference/sql/show-grants.html
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#:~:text=to%20the%20share.-,SHOW%20GRANTS%20OF,-...
A is correct.
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