Hugo FOULON on 04 Apr 2024 14:25:33
We have 2 levels of access in our dashboards :
- security groups associated with powerbi apps : a user can or can't open a dashboard
- Row Level Security : a user can only see his/her subsidiary (country)
To configure RLS, we have a subsidiary table in the dataset (see screenshot), filtered on a table in the database associating users and subsidiaries.
Generally it works, but sometimes, after one of the developers makes an evolution, users can see all subsidiaries (join badly configured, see the other screenshot).
I am not allowed to display data from a subsidiary the user is not working for. When we realize it, we make a correction in the dataset and it is solved.
But we can take up to 2 months to realize. As a Data Manager, i need to receive an alert as soon as RLS is broken.
- Comments (1)
RE: I need to reveive an alert when Row Level Security is broken
In addition, it is linked to some DevOps principles : we want the developers to deploy evolutions as frequently as possible, while maintaining a good quality/reliability level.To do so, we can implement alerting and automated tests. This idea is really about that.