Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

This is something you would do in your own system, this wouldn't be done using `auth.role()` as this only have a few roles. Take a look at https://supabase.io/docs/guides/auth#policies-with-joins as an example

Someone asked a similar question in the <#869405720934744086> channel and there is an example there you can build off https://discord.com/channels/839993398554656828/869405720934744086/883338240273297410

<@!107176742342402048> thanks for the links. I'll have a look and continue in that thread

Let's keep the threads separate as the original author of that thread's issue has been resolved

You can create complex joins in RLS to get the granularity you are after https://github.com/supabase/supabase/discussions/811