Forum Discussion
is column level security really available in sql server 2019
Hi stanteitelbaum ,
SQL Server does not support true Column-Level Security (OLS) natively only Row-Level Security (RLS) is supported. OLS can be simulated using views and SYSTEM_USER(), but this approach is manual and not secure for sensitive data unless combined with other controls.
Power BI does not detect SQL column restrictions via USERPRINCIPALNAME() unless you are using Direct Query.
SQL enforces security using views and SYSTEM_USER() or SUSER_SNAME().
To ensure safer, scalable security that aligns with Power BI’s behaviour, split sensitive data into separate tables and apply RLS.
Thank you!!
Hi stanteitelbaum ,
Thank you for reaching out to Microsoft Fabric Community.
Below documentation could help you in implementing OLS. Please review it and let us know if need any further assistance.
https://learn.microsoft.com/en-us/fabric/security/service-admin-object-level-security
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!
that seems to be related to a different subject. but thx.