Forum Discussion

nok's avatar
nok
Advocate II
1 year ago
Solved

RLS not working for only one table

Hi! I created RLS for several tables in my report, all following the same code (except for the last part where I change the respective table reference). This is the code: var _User = USERPRINCIPAL...
Need Help
Show and Tell
Tutorial Requests
  • nok's avatar
    nok
    1 year ago

    I managed to solve this issue by doing a workaround because for some reason RLS doesn't seem to work with bidirectional many-to-many relationships. That was the problem. So to "solve" this, I needed to create a bridge table with two columns: one for the distinct ID that would relate to all the other tables, and another for the RLS Code. Then I applied RLS only to this bridge table, and it worked.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi nok ,

 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

 

Thank you.

nok's avatar
nok
Advocate II
1 year ago

I managed to solve this issue by doing a workaround because for some reason RLS doesn't seem to work with bidirectional many-to-many relationships. That was the problem. So to "solve" this, I needed to create a bridge table with two columns: one for the distinct ID that would relate to all the other tables, and another for the RLS Code. Then I applied RLS only to this bridge table, and it worked.