COF-C03: SnowPro Core Certification

By Snowflake · Question Mode

QuestionQ36

Account Management & Data Governance

An account must share a secure view in Database B that references a table in Database A. Which steps are required?

Explanation

A share is an account-level object. For a secure view that is created in Database B and references an object in Database A, the share needs USAGE on Database B and the view’s schema, SELECT on the secure view, and REFERENCE_USAGE on Database A. Snowflake does not grant USAGE on both databases to the same share for this pattern.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!