code '42501', details null, hint null, message 'permission denied for schema ' error. what do i do?
11 Replies
using @nuxt/supabase client
Are you using Prisma? You are using a capital named table which is a bad idea, but Prisma forces that. Prisma also plays games with the grants on the schemas.
yes. using prisma.
Prisma | Supabase
Connect your Supabase postgres database to your Prisma project.
is there a workaround?
thank you. will i have to run this every time i do a mirgation?
I don't use Prisma, so not sure.
that worked. thank you so much
Normally I think you access the database thru Prisma and not thru the API, when using it, but not sure.
i was trying to run some seeding scripts
but i think prisma has a seeding algo
thank you though
Yea they do, just make a seed.ts and add it to package.json for prisma
I never needed to run this, so maybe it’s a one-off for u
thank you @NanoBit