Row Level Security - User Filter on Multiple Fields

Hi,

I'm trying to implement row level security using a user filter.

I have 3 tables (with hierarchy) in my database containing user access info:

Table 1 - user access at Department Level (highest hierarchy)

Table 2 - user access at Team Level

Table 3 - user access at Personal Level (lowest hierarchy)

Each table has no overlap (i.e. if a user has access at department level, they he has access for all teams/persons information under that department so there will be no record of the same information for this user at team/personal level).

I tried to add a user filter on each table but it didn't work since the tables have no overlap (when filter by department 1, I cannot see information of teams in department 2 even I have the team level access). How can I set up my user filter with an 'OR' statement on fields of these 3 tables based on the access hierarchy? Any suggestions?

Thanks