Forum Discussion

dirkmuis's avatar
dirkmuis
Icon for Helper II rankHelper II
7 years ago

RLS and relations issue

So I have set-up tables for RLS as advised here. I have a user and usergroup table. And a test user in both of them.   But I'm strugling with the rest of my relations. User has the RLS off course...
Need Help
dirkmuis's avatar
dirkmuis
Icon for Helper II rankHelper II
7 years ago

Very strange thing is that when I add the table visual and add courseID from courserequest I only see the relevant data. If I add courseID from tblcourse I see all data.

 

So does that relation for some reason only work when you add the FK from the underlying table?