Column level security and row level security for a KQL database

[pmscorca]

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

[Anonymous · Accepted solution]

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-diffe... 

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.

[pmscorca]

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.

[tackytechtom]

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/