Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    If you are an Admin, Member or Viewer of the workspace, RLS will not apply
    • Anonymous's avatar
      Anonymous
      Not 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?