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?

Alan Coutinho · Accepted Answer

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

Alan Coutinho · Answer

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

Alan Coutinho · Answer

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

Alan Coutinho · Answer

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

List of questions