User Profile
hominid
New Member
Joined 1 year ago
User Widgets
Contributions
Automated check of Row-Level Security policy at SQL Endpoint
We will be implementing Row-Level Security at the SQL endpoint for a data product and there is some concern about the potential, even if unlikely, risk of the RLS policy getting dropped either through someone accidentally dropping it or a bug. For instance there seems to be a known bug Known issue - SQL analytics endpoint tables lose permissions - Microsoft Fabric | Microsoft Learn where permissions can be impacted at the SQL endpoint. I'm wondering is there a known way to set up an automated check of the status of the RLS policy, so that the policy can be re-applied or at least someone alerted if the policy gets dropped? In particular it would be nice to have an automated post-deployment check. Any insights or pointers would be much appreciated.Solved2.6KViews0likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.