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
    9 months ago

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

munindra's avatar
munindra
Frequent Visitor
9 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
9 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.