Forum Discussion
Row Level Security
Hi everyone, i have an issue with a report where we have RLS eneabled. We have 2 roles. - The first role filters data according to the user info with the following rule [User Name] = ...
two things to get you started
- there is a difference between USERNAME and USERPRINCIPALNAME. Don't use USERNAME.
- note that RLS will be ineffective if the user has workspace access above Viewer.
Ok thanks. I'll try USERPRINCIPALNAME() instead and see if that works.
And yeah, i noticed that RLS behaves differently depending on the level of acces the user has in the workspace.
I i can't get the user to work with RLS, i'll try and give her higher acces than viewer since she can see all the data without restriction.
