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

Question

Anna Fagulova · Accepted Answer

Which statements will provide this access?

Anna Fagulova · Answer

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

Anna Fagulova · Answer

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

Anna Fagulova · Answer

GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K'-'SCHEMA TO USER! ;

Anna Fagulova · Answer

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

List of questions