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

Question

Joseph Daly · Accepted Answer

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

Joseph Daly · Answer

Use the CURRENT_ROLE and CURRENT_USER functions to validate secure views.

Joseph Daly · Answer

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

Joseph Daly · 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