Securing rows based on another table.

In the image provided, I have 3 tables.

Firstly, I am wanting to restrict access to the

accounts

accounts

so that a user can only access it if they are a

account manager

account manager

.

I also have a

published_status

published_status

table, which I only want to allow

account managers

account managers

to have access.

How would this be done?

Securing rows based on another table. - Supabase