Forum Discussion
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 not working on materialized lake views.
Can you confirm whether this is expected or it is a bug?
Thanks!
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.
3 Replies
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.
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.
