SnowPro Core Certification — Question 411
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?
Answer options
- A. SHOW GRANTS ON ROLE DATA_SCIENCE
- B. SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING
- C. SHOW GRANTS TO USER INQUISITIVE_PERSON
- D. SHOW GRANTS OF ROLE DATA_SCIENCE
Correct answer: B
Explanation
The correct command to display all privileges for the MARKETING schema is 'SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING' (option B). Options A and D relate to grants on the role itself rather than the schema, while option C focuses on the grants for the specific user, not the schema privileges.