SnowPro Advanced Administrator ADA-C02

By Snowflake · Question Mode

QuestionQ43

Perform data sharing and use the Snowflake Marketplace

When adding secure views to a share in Snowflake, which function is required to authorize users from another account to access rows in a base table?

Explanation

For secure views used with Snowflake Secure Data Sharing, CURRENT_ACCOUNT identifies the consumer account and can be used to authorize access to specific base-table rows. CURRENT_ROLE and CURRENT_USER return NULL when the secure view is shared with another Snowflake account.

Learn more

Community Discussion

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