Supabase SQL: Allow company owner to access all employee data while restricting employees to their own data
I’m developing a Next.js application with Supabase as the backend. I need to implement Row Level Security (RLS) policies that allow a company owner to view and manage data for all employees in their company, while restricting regular employees to only their own data. My setup includes separate authentication and employee tables.