Forum Discussion
Post ProdigyColumn level security and row level security for a KQL database
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 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.
pmscorcaHi,
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.