A user named USER_01 needs access to create a materialized view on a schema EDW. STG_SCHEMA. How can this access be provided?

Question

Options

• AGRANT CREATE MATERIALIZED VIEW ON SCHEMA EDW.STG_SCHEMA TO USER
• BGRANT CREATE MATERIALIZED VIEW ON DATABASE EDW TO USER USERJD1;
• CGRANT ROLE NEW_ROLE TO USER USER_01;
• DGRANT ROLE NEW_ROLE TO USER_01;

• A
  93% (51)
• B
  2% (1)
• C
  4% (2)
• D
  2% (1)

Explanation

In Snowflake, the CREATE MATERIALIZED VIEW privilege is a schema-level privilege, not a database-level one. The correct syntax to grant this directly is: GRANT CREATE MATERIALIZED VIEW ON SCHEMA EDW.STG_SCHEMA TO USER USER_01 (Option A). Option B is incorrect because this privilege cannot be granted at the DATABASE level. Options C and D both reference granting a role (NEW_ROLE) to the user, but without knowing what privileges NEW_ROLE has, they don't guarantee CREATE MATERIALIZED VIEW access. Option D also has incorrect syntax - it's missing the USER keyword before USER_01.

No community discussion yet for this question.