Comment
New Contributor II

Hi @jeffreyaven ,

Thanks for the great article! I have one question regarding the recipient-based access control scenario.

If multiple recipients are created using the same sharing identifier, how does Databricks determine which recipient's properties are returned by current_recipient() at query time?

For example, if Mario (Italy) and Pierre (France) are both accessing the same Delta Share from the same consumer Databricks workspace/metastore, how does Databricks decide whether to use the italy_partner or france_partner recipient? Can current_recipient() differentiate between users within the same consumer workspace, or is it always resolved at the recipient/metastore level?

Thanks in advance for your clarification!