Hi everyone! 👋 This is my first post here, so please bear with me — and thanks in advance for any help!
I'm building a React app using Clerk for authentication and Supabase as my backend, with Clerk integrated as a third-party auth provider.
I understand how to use Supabase RLS policies to allow authenticated users to create, update, and delete their own records. However, I also have a separate group of users who need to moderate content created by others (for example: approve, edit, or delete posts).
What is the recommended way to handle authorization for these moderator users with Supabase RLS when using Clerk? Should this be done via custom claims, role tables, JWT metadata, or another approach?
For reference, this is the video I followed for the Clerk + Supabase integration: 👉 How Clerk integrates with Supabase: https://youtu.be/hcw38fUPNbw?si=37B8ErSeMueWhHdd
The user is building a React app using Clerk for authentication and Supabase as the backend. They need guidance on implementing authorization for moderator users using Supabase RLS with Clerk. They are considering options like custom claims, role tables, or JWT metadata.