SnowPro Advanced Administrator ADA-C02

By Snowflake · Question Mode

QuestionQ45

Perform data sharing and use the Snowflake Marketplace

An Administrator receives data from a Snowflake partner. The partner shares a dataset containing multiple secure views. The Administrator wants to configure access so that only specific roles can view specific secure views.

How can this be achieved?

Explanation

Imported databases are read-only, and granting IMPORTED PRIVILEGES grants access to all objects in the share rather than enabling role-specific access to a subset. Views created in a company-owned database can reference the incoming shared database and can receive the required RBAC grants, restricting each role to the intended view.

Learn more

Community Discussion

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