Forum Discussion
Solved
RLS Many users linked to many companies
I need to be able to apply row level security and I have the following structure: With the following permissions: And this works to filter the reports by user, if userX belong...
Looks like you need to make your User to UserTenant relationship bi-directional or at least have the User table filter the UserTenant table. Then if a user is in more than one tenant it should work. Alternatively, have your RLS rule based upon UserTenant instead of User.
Greg_Deckler
Community Champion
Community ChampionLooks like you need to make your User to UserTenant relationship bi-directional or at least have the User table filter the UserTenant table. Then if a user is in more than one tenant it should work. Alternatively, have your RLS rule based upon UserTenant instead of User.
Doing both changes worked, thank you!