A new user, user_01, is created in Snowflake. The following two commands are executed:
user_01
show grants to user user_01;
show grants on user user_01;
What inferences can be made about these commands?
SHOW GRANTS TO USER user_01 lists the access-control privileges granted to user_01. SHOW GRANTS ON USER user_01 lists grants on the user object, including its OWNERSHIP privilege; Snowflake objects, including users, are owned by roles.
SHOW GRANTS TO USER user_01
SHOW GRANTS ON USER user_01
Community Discussion