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?

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?

shridhar deshpande · Accepted Answer

SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

shridhar deshpande · Answer

SHOW GRANTS ON ROLE DATA_SCIENCE

shridhar deshpande · Answer

SHOW GRANTS TO USER INQUISITIVE_PERSON

shridhar deshpande · Answer

SHOW GRANTS OF ROLE DATA_SCIENCE

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 308 - COF-R02 discussion

Suggested answer: B

0 comments