Forum Discussion

munindra's avatar
munindra
Frequent Visitor
9 months ago
Solved

How to Dynamically Set Tenant Context in Fabric SQL Warehouse with MFA Login and RLS

I’m implementing Row-Level Security (RLS) in Microsoft Fabric SQL Warehouse for a multi-tenant architecture. The goal is to filter data based on TenantID using SESSION_CONTEXT and a security policy a...
data engineering
Lakehouse
  • munindra's avatar
    munindra
    8 months ago

    By passing the SESSION_CONTEXT directly into the function rather than creating a seperate logic i am able to resolve this issue

v-hashadapu's avatar
v-hashadapu
Community Support
8 months ago

Hi munindra , 

hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.

 

munindra's avatar
munindra
Frequent Visitor
8 months ago

By passing the SESSION_CONTEXT directly into the function rather than creating a seperate logic i am able to resolve this issue

  • v-hashadapu's avatar
    v-hashadapu
    Community Support
    8 months ago

    Hi munindra , Thanks for the update and the information. We are happy to know that you have resolved your issue. If you have any other queries/issues, feel free to create new posts, we are always happy to help.