Forum Discussion
Column level security and row level security for a KQL database
Hi,
I'd like to know if a KQL database supports the column level security and the row level security. Reading the documentation it doesn't seem. I'm not referred to Power BI's level securities.
Thanks
Hi pmscorca ,
Thanks for tackytechtom's reply!
And pmscorca , The security of the KQL database is implemented on an by-account basis, not by the compute engine, so it can only implement RLS but not CLS.https://blog.fabric.microsoft.com/en/blog/lakehouse-vs-data-warehouse-deep-dive-into-use-cases-differences-and-architecture-designs?ft=07-2023:date
For information on how to implement RLS see the link provided by tackytechtom.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi pmscorca ,
For RLS, have you tried this one here?Row Level Security - Kusto | Microsoft Learn
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/Hi pmscorca ,
Thanks for tackytechtom's reply!
And pmscorca , The security of the KQL database is implemented on an by-account basis, not by the compute engine, so it can only implement RLS but not CLS.https://blog.fabric.microsoft.com/en/blog/lakehouse-vs-data-warehouse-deep-dive-into-use-cases-differences-and-architecture-designs?ft=07-2023:date
For information on how to implement RLS see the link provided by tackytechtom.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi,
however it could be useful to have the CLS for a KQL database.
Copilot suggests that the CLS is possible with the .add column policy ... on ... statement.
