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?

luis coco enriquez · Accepted Answer

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

luis coco enriquez · Answer

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

luis coco enriquez · Answer

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

luis coco enriquez · Answer

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

List of questions