COF-C03: SnowPro Core Certification

Question

The following application roles exist in a company's environment: DEVELOPER_ROLE and ETL_ROLE. Both roles have been granted USAGE, CREATE, and SELECT privileges on the same database and schema table object.

A user using DEVELOPER_ROLE creates a new table named MYTABLE in the MYDB.MYSCH schema. When a user using ETL_ROLE tries to access MYDB.MYSCH.MYTABLE, they receive an insufficient-privileges error.

Which statement enables ETL_ROLE to access MYDB.MYSCH.MYTABLE when it is created?

Explanation

A future SELECT grant on tables in MYSCH assigns SELECT to ETL_ROLE automatically for tables subsequently created in that schema. Database and schema privileges alone do not grant SELECT on a newly created table, which is owned by the role that creates it.

Learn more

Snowflake Documentation — GRANT <privileges> … TO ROLE

COF-C03: SnowPro Core Certification

AstroTutor

Notes

Readiness

QuestionQ68

Community Discussion