Hey! guys is there a way to convert an sql table to the supabase ways of doing it?

I mean what you have should already work with postgres

It is about creating policies around those tables

But a table like that wouldn't be used unless you aren't making use of Supabase Auth

I am making use of supabase auth as well

Maybe if you state what you are trying to accomplish it will be easier to assist you

I was thinking to just use Prisma to get things started but then I will be missing out on the Supabase auth

I meant what are you trying to accomplish with the table schema you posted?

I want to implement a role base ACL and also wanna use Supabase Auth as my auth method

You can just create a roles table then and another table with users_roles, then you can use RLS to check against that table to know if a user has certain access rights to certain data

Thanks