Snowflake
COF-R02 · Question #308
User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW. Which command will show all…
The correct answer is B. SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING. See the full explanation below for the reasoning.
Question
User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW. Which command will show all privileges granted to that schema?
Options
- ASHOW GRANTS ON ROLE DATA_SCIENCE
- BSHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING
- CSHOW GRANTS TO USER INQUISITIVE_PERSON
- DSHOW GRANTS OF ROLE DATA_SCIENCE
How the community answered
(26 responses)- A15% (4)
- B77% (20)
- C4% (1)
- D4% (1)
Community Discussion
No community discussion yet for this question.