Securing rows based on another table.

In the image provided, I have 3 tables.

Firstly, I am wanting to restrict access to the accounts so that a user can only access it if they are a account manager.

I also have a published_status table, which I only want to allow account managers to have access.

How would this be done?
unknown.png
Was this page helpful?