Sample Header Ad - 728x90

Can OPENROWSET authenticate with the signed in user running the query?

1 vote
1 answer
656 views
My architecture is as follows: 1. On prem sql server database [Datawarehouse] 2. Azure Analysis Services Tabular model [Sales] 3. International report developers that query the [Datawarehouse] to develop reports* 4. RLS on tables in [Datawarehouse] 5. RLS on [Sales] tabular model For testing that our data makes it correctly from [Datawarehouse] to [Sales] I would like to create a view on the [Datawarehouse] that uses OPENROWSET() to connect to the [Sales] tabular model. The only issue with this is I can see the user that runs the OPENROWSET() query on the [Sales] model is our sql admin user, not myself. Is there a way to configure the OPENROWSET() so that the user that is executing the local query is also the user that executes the query on the linked server? As far as I can tell, passthrough credentials would be the best way to ensure proper security is maintained. *the only reason I mention "international" is because the RLS is based on country
Asked by Antyan (158 rep)
Apr 4, 2022, 07:48 PM
Last activity: Apr 5, 2022, 12:29 AM