Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

RLS row level security - not showing online

Hi Everyone -  I have created the following role in my sales table.      [Salesperson (groups)] = "HSRs"   In the online enviornment, if I choose "test role", it works perfectly and only shows th...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    That's correct, it's just them being members that is causing RLS to be ignored.

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
6 years ago

That's correct, it's just them being members that is causing RLS to be ignored.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you!   Just tested it and everything is working properly at the team level.   

 

I've seen some good tutorials on how to apply a "path" if I wanted to go from Manager...down to sales people...to see a hiearchy in the sales team.  Will tackle that next.    

 

I will mark this thread as solved!  

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    6 years ago

    You should also create and executive role where no filters are applied.  With RLS enabled, if a user that is not in a role and is not a member of the workspace goes to view the report they will see nothing.

    Or you could make the execs members of the workspace.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    That is great to know....as it is exactly a requirement I will have.