Dynamic RLS One Region Manager Covering Multiple Regions

[etane]

Hello. 

I currently have a Sales table filtered by RLS via Region column in Sales Person table.  So, each regional manager can only see sales per their region.

However, now I need one Region Manager to be able to access sales in two regions.  I've set up tables as such below.  However, RLS doesn't seem to be filtering now.  

What adjustments do I need to make to allow one Region manager to access multiple Sales region?

Thanks.

[etane]

@lbendlinthanks I didn't know it could be done with many to many.

[lbendlin · Accepted solution]

What do you need the bridge table for?  It will not help your RLS as it is bidirectionally joined. Eliminate the bridge table and connect the Sales Person table to the Sales table in a *:*  BUT single direction join.