What is the appropriate command to provide the access?
A user needs access to create materialized view on a shema mydb.myschema. What is the appropriate command to provide the access?A . GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE; B. GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1; C. GRANT...