Command 1: show grants to user user_01;
This command displays what privileges (roles) have been granted to the user "user_01."
Command 2: show grants on user user_01;
This command shows which roles have what privileges (for example, OWNERSHIP or USAGE) on the "user_01" object itself (the user), in other words, the privileges granted on "user_01." If the object is a USER, the privilege is OWNERSHIP.
Please try these commands yourself.
https://docs.snowflake.com/en/sql-reference/sql/show-grants
Command 1: show grants to user user_01; This command lists all the roles granted to the user user_01.
Command 2: show grants on user user_01; This command lists all the privileges that have been granted on the user object user_01.
https://docs.snowflake.com/en/sql-reference/sql/show-grants
SHOW GRANTS TO USER user_01: Lists all the roles granted to the user_01.
SHOW GRANTS ON USER user_01: Lists all privileges granted to the user user_01.
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
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
ArunH
1 day, 13 hours ago785de4c
3 months, 1 week agoArkitekt
6 months, 2 weeks agoKindleAce
1 year agoNachoPrendes
1 year, 4 months ago