A user named USER_01 needs access to create a materialized view on a schema EDW. STG_SCHEM

The CREATE MATERIALIZED VIEW privilege is a schema-level privilege. The correct syntax to grant this permission directly to a user for a specific schema is GRANT CREATE MATERIALIZED VIEW ON SCHEMA TO USER . Option A follows this syntax precisely, granting the required privilege on the EDW.STGSCHEMA to USER01. While using roles is a best practice, this direct grant is a valid and correct way to provide the specified access.

B. This grants the privilege on the entire database EDW, which is overly permissive, and contains a typo in the username (USERJD1).
C. This option contains multiple typos in the object name (ECW.STGSCHEKA instead of EDW.STGSCHEMA), making the command invalid for the intended schema.
D. The second GRANT statement is syntactically incorrect. It is missing the object type keyword SCHEMA before the object name EDW.STGSCHEMA.

1. Snowflake Documentation: Access control privileges - Schema Privileges. This document lists CREATE MATERIALIZED VIEW as a privilege that can be granted on a schema.

Reference: Snowflake Inc. (2023). Access control privileges. Snowflake Documentation. Retrieved from https://docs.snowflake.com/en/user-guide/security-access-control-privileges#schema-privileges

2. Snowflake Documentation: GRANT . This page details the syntax for granting privileges on various database objects. The correct syntax for a schema is GRANT ON SCHEMA TO ....

Reference: Snowflake Inc. (2023). GRANT . Snowflake Documentation. Retrieved from https://docs.snowflake.com/en/sql-reference/sql/grant-privilege (See section: "Syntax" and "Examples").