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

Question

Mykhailo Vavilov · Accepted Answer

Which statements will provide this access?

Mykhailo Vavilov · Answer

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

Mykhailo Vavilov · Answer

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

Mykhailo Vavilov · Answer

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

Mykhailo Vavilov · Answer

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

List of questions