A new user user_01 is created within Snowflake. The following two commands are executed:
Command 1 --> show grants to user user_01;
Command 2 --> show grants on user user_01;
What inferences can be made about these commands?
A new user user_01 is created within Snowflake. The following two commands are executed:
Command 1 --> show grants to user user_01;
Command 2 --> show grants on user user_01;
What inferences can be made about these commands?
Command 1 'show grants to user user_01;' defines all the grants which are given to user_01. Command 2 'show grants on user user_01;' defines which user owns user_01. Command 1 lists the roles and privileges assigned to the user, whereas Command 2 lists the entity (either another role or an account) that has ownership rights over the user account.
Checked on Snowflake https://docs.snowflake.com/en/sql-reference/sql/show-grants#:~:text=the%20demo%20user%3A-,SHOW%20GRANTS%20TO%20USER,-demo%3B%0A%0A%2B