Forum Discussion
Row Level Security on web portal not working
Hi,
I'm creating a sample report with Row Level Security applied that is perfectly working on my Desktop version but when I publishing it, it doesn't work properly. The weird thing is that I can see all the data when I shouldn't.
Table A: EmployeeId, EmployeeName
Table B: EmployeeId, Email ([email protected])
Both tables joined by EmployeeId, BOTH directions applied, and "Apply security filter" option checked.
I used the "View as" option in the desktop with several users and the data is being filtered as expected, but when I publish it in the portal, I can see more data than expected.
I also added a card in the report using the USERNAME () expression, just to be sure that the login is fine, but the user is the one I expected.
Is there something I'm forgetting to do once it is deployed?
Thanks in advance
- If you are an Admin, Member or Viewer of the workspace, RLS will not apply
2 Replies
- Greg_Deckler
Community Champion
If you are an Admin, Member or Viewer of the workspace, RLS will not apply- AnonymousNot applicable
Hi,
Thanks, that gives a proper explanation to what's happening to my report, but makes me ask another question.
Then, what role should the user have to have the RLS applied? because basically you mentioned all the roles for a workspace except the contributor? Or should it be just a shared report with no access to the workspace?