Exam4Training

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;

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.

Latest ARA-C01 Dumps Valid Version with 156 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version