How to integrate clerk org role based auth with supabase row level security in database and storage.
Sorry to ask it here, but no one replying in supabase. So maybe someone who has solved this problem can tell me. I am using t3-stack along with clerk as auth and supabase for database and storage. Can you please show me how to implement clerk org roles in supabase RLS correctly. Currently both the supabase and clerk docs doesn't mention user roles.
A workaround solution can be to create a users table and add clerk data to it through webhooks and use it for RLS policies. Since adding the clerk data directly to auth table looks impossible. If this solutions sounds good please tell me how to do it. If not then what should I do?
0 Replies