Hello,
I would like to create a DATA PAGE that only gives access to SALES MANAGERS to then view a list of customers created by 1) himself and 2) by users within his team. I do not want SALES MANAGER "A" to be able to see SALES MANAGER "B" listings. There will be a team of 5 people assigned to Manager "A" and a team of 10 people assigned to MANAGER "B".
1. If MANAGER "A" logs in, I want him to see his customers as well as ALL of his teams customers.
2. If a user logs in, then I want him to see only his customers (nobody else from the team)
Is this possible with RLS? How do I accomplish this?