Forum Discussion

sahinad's avatar
sahinad
Frequent Visitor
8 months ago
Solved

OneLake RLS Security on Materialized Lake Views

Hi, I couldn't find anywhere an explicit statement that OneLake RLS Security is not supported yet on materialized lake views. I have tested it before on tables and it's worked fine. However, it is...
one lake
  • nielsvdc's avatar
    nielsvdc
    8 months ago

    Hi sahinad, RLS is enforced only on base tables; applying it to MLVs is not yet support. That is because MLVs are persisted query results managed by Fabric, but they are not treated as standard Delta tables for security purposes yet.

     

    Hopefully the support will get on the roadmap soon.

     

    Hope this helps. If so, please give kudos 👍 and mark as Accepted Solution ✔️ to help others.

nielsvdc's avatar
nielsvdc
Super User
8 months ago

Hi sahinad, RLS is enforced only on base tables; applying it to MLVs is not yet support. That is because MLVs are persisted query results managed by Fabric, but they are not treated as standard Delta tables for security purposes yet.

 

Hopefully the support will get on the roadmap soon.

 

Hope this helps. If so, please give kudos 👍 and mark as Accepted Solution ✔️ to help others.

  • sahinad's avatar
    sahinad
    Frequent Visitor
    8 months ago

    Thanks for the clarification and the quick reaction nielsvdc.

    • v-veshwara-msft's avatar
      v-veshwara-msft
      Community Support
      8 months ago

      Hi sahinad ,
      Thanks for reaching out to Microsoft Fabric Community and for the confirmation.

      The details provided by nielsvdc  are correct and reflects the current product behavior. RLS is enforced only on base tables, and it is not available for materialized lake views at this stage. Support for this area may come in future releases as the feature continues to evolve.

       

      Please reach out for further assistance.

      Thank you.