SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ53

VerifiedSecure Data Sharing and Consumption

A new user, user_01, is created in Snowflake. The following two commands are executed:

show grants to user user_01;

show grants on user user_01;

What inferences can be made about these commands?

Explanation

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.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!