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. To show all privileges granted to a specific schema, the command SHOW GRANTS ON SCHEMA <schema_name> should be used. In this case, it would be SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING.

Account Access and Security

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

(22 responses)

A
5% (1)
B
91% (20)
C
5% (1)

Explanation

To show all privileges granted to a specific schema, the command SHOW GRANTS ON SCHEMA <schema_name> should be used. In this case, it would be SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING.

Topics

#SHOW GRANTS#Access Control#Schema Privileges#SQL Syntax

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice