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 CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

View Answer

Answer: A

Explanation:

By design, snowflake privileges cannot be granted to USER, It always needs to be granted to a ROLE.

Hence the user needs to be granted the ROLE first and then the privilege will be granted to the ROLE.