Lakehouse Federation for SQL Server and Security Policy

marcuskw
Contributor II

‎04-10-2024 06:48 AM

We've been able to setup a Foreign Catalog using the following documentation:
https://learn.microsoft.com/en-us/azure/databricks/query-federation/sql-server

However the tables that have RLS using a Security Policy appear empty. I imagine that this solution is not able to use the Functions and respective Security Policy?
I can confirm that once disabling the Security Policy I was able to see the relevant data in the table.

The Security Policy is setup using SUSER_NAME().

0 Kudos

marcuskw
Contributor II

‎04-10-2024 07:20 AM

Was a bit quick here, found out that the SUSER_NAME() of the query is of course the connection that was setup.
So the User/Password defined here:

Skjermbilde 2024-04-10 161751.png

Once I added that same user to the RLS logic I get the correct result.

 

View solution in original post

0 Kudos