Which SQL command can be used to verify the privileges that are granted to a role?
Which SQL command can be used to verify the privileges that are granted to a role?
The correct SQL command to verify the privileges that are granted to a role is 'SHOW GRANTS TO ROLE <role name>'. This command lists all privileges and roles that have been granted to a specified role.
Answer shown does not even exist. Show grants to role: List all privileges granted https://docs.snowflake.com/en/sql-reference/sql/show-grants.html#show-grants
https://docs.snowflake.com/en/sql-reference/sql/show-grants.html#show-grants
SHOW GRANTS TO ... ROLE role_name Lists all privileges and roles granted to the role.
https://docs.snowflake.com/en/sql-reference/sql/show-grants
C obviously
show grants to role; generate results for all granted privileges of the role.