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
Last activity: Apr 5, 2022, 12:29 AM