Forum Discussion

Allard_Swart's avatar
Allard_Swart
Regular Visitor
4 years ago
Solved

Row Level Security no longer works when displaying the table with the RLS filter

Hi everyone,   First of all thank you for looking into my question. I had RLS set up for my report and it was working fine, but for some reason it doesn't anymore. While it still filters the result...
Need Help
  • FarhanAhmed's avatar
    FarhanAhmed
    4 years ago

     Cardinality Should be set to "One to Many" instead of "Many to One" since your export table has single Plan and user table should have multiples.

FarhanAhmed's avatar
FarhanAhmed
Icon for Community Champion rankCommunity Champion
4 years ago

Click on "Apply security filters on both directions"

  • Allard_Swart's avatar
    Allard_Swart
    Regular Visitor
    4 years ago

    Hi FarhanAhmed,

    Thanks for your reply. I tried doing that, but it gives me an error

    It says that because I use it for RLS I can't set the filter behavior for both directions/

     

    • FarhanAhmed's avatar
      FarhanAhmed
      Icon for Community Champion rankCommunity Champion
      4 years ago

       Cardinality Should be set to "One to Many" instead of "Many to One" since your export table has single Plan and user table should have multiples.

      • Allard_Swart's avatar
        Allard_Swart
        Regular Visitor
        4 years ago

        I think the problem is that we've turned the relationship into a many to many relationship while it used to be a one to many.

         

        Right now we were giving rights based on programs, but it seems that we need to switch to giving rights to a cluster or programs instead. (or give the option to do so). That should probably fix it.

         

        Thanks for the help, it made it clear where the problem was. I'll post to let everyone know if the fix that comes out of this will solve the problem.