A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?

Question

A user needs to create a materialized view in the schema MYDB.MYSCHEMA.Which statements will provide this access?

Rajeev Parameswaran · Accepted Answer

GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Rajeev Parameswaran · Answer

GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

Rajeev Parameswaran · Answer

GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

Rajeev Parameswaran · Answer

GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

List of questions