Snowflake
COF-R02 · Question #157
What SQL command would be used to view all roles that were granted to user.1?
The correct answer is A. show grants to user USER1. See the full explanation below for the reasoning.
Question
What SQL command would be used to view all roles that were granted to user.1?
Options
- Ashow grants to user USER1;
- Bshow grants of user USER1;
- Cdescribe user USER1;
- Dshow grants on user USER1;
How the community answered
(40 responses)- A78% (31)
- B5% (2)
- C5% (2)
- D13% (5)
Community Discussion
No community discussion yet for this question.