How can a data provider ensure that a data consumer is going to have access to the required objects?

Question

Natcha Koopipat · Accepted Answer

Enable the data sharing feature in the account and validate the view.

Natcha Koopipat · Answer

Use the CURRENT_ROLE and CURRENT_USER functions to validate secure views.

Natcha Koopipat · Answer

Use the CURRENT_ function to authorize users from a specific account to access rows in a base table.

Natcha Koopipat · Answer

Set the SIMULATED DATA SHARING CONSUMER session parameter to the name of the consumer account for which access is being simulated.

List of questions