Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake ARA-R01 Exam - Topic 2 Question 42 Discussion

Actual exam question for Snowflake's ARA-R01 exam
Question #: 42
Topic #: 2
[All ARA-R01 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: D

The SHOW GRANTS command in Snowflake can be used to list all the access control privileges that have been explicitly granted to roles, users, and shares.The syntax and the output of the command vary depending on the object type and the grantee type specified in the command1. In this question, the two commands have the following meanings:

Command 1: show grants to user user_01; This command lists all the roles granted to the user user_01. The output includes the role name, the grantee name, and the granted by role name for each grant.This command is equivalent to show grants to user current_user if user_01 is the current user1.

Command 2: show grants on user user_01; This command lists all the privileges that have been granted on the user object user_01. The output includes the privilege name, the grantee name, and the granted by role name for each grant.This command shows which role owns the user object user_01, as the owner role has the privilege to modify or drop the user object2.

Therefore, the correct inference is that command 1 defines all the grants which are given to user_01, and command 2 defines which role owns user_01.


SHOW GRANTS

Understanding Access Control in Snowflake

by Destiny at Mar 05, 2026, 12:30 PM

Limited Time Offer

25%

Off

Get Premium ARA-R01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Truman
3 days ago
I think both commands are about grants, but I can't recall which one shows ownership. It feels like a practice question we did.
upvoted 0 times
...
Wilda
8 days ago
I remember that "show grants to user" is supposed to show the privileges assigned to a user, but I'm not sure about the second command.
upvoted 0 times
...
Detra
13 days ago
I feel like Command 1 is about grants, but I’m confused about Command 2. I thought it was about ownership, but it could be roles too.
upvoted 0 times
...
Elenora
18 days ago
From what I studied, Command 1 should show all the grants given to user_01, but I can't recall if Command 2 is about ownership or roles.
upvoted 0 times
...
Tashia
24 days ago
I remember practicing a similar question, and I think Command 1 is definitely about grants. Command 2 might be about ownership too, but I'm not 100% certain.
upvoted 0 times
...
Leanora
29 days ago
I think Command 1 shows the grants for user_01, but I'm not sure what Command 2 does exactly. It might be about ownership?
upvoted 0 times
...

Save Cancel