A user needs to create a materialized view in the schema MYDB.MYSCHEM

The correct answer is A. Which statements will provide this access? To provide a user with the necessary access to create a materialized view in a schema, the user must be granted a role that has the CREATE MATERIALIZED VIEW privilege on that schema. First, the role is granted to the user, and then the privilege is granted to the role.

Account Access and Security

Question

Options

AWhich statements will provide this access?
BGRANT ROLE MYROLE TO USER USER1;
CGRANT ROLE MYROLE TO USER USER1;
DGRANT ROLE MYROLE TO USER USER1;
EGRANT ROLE MYROLE TO USER USER1;

How the community answered

(29 responses)

A
86% (25)
B
3% (1)
C
3% (1)
E
7% (2)

Explanation

To provide a user with the necessary access to create a materialized view in a schema, the user must be granted a role that has the CREATE MATERIALIZED VIEW privilege on that schema. First, the role is granted to the user, and then the privilege is granted to the role.

Topics

#Materialized Views#Access Control#Privileges#Schema Permissions

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice