Supabase + Prisma & db users
# sql
j
Supabase + Prisma & db users
I created a project with Remix, Supabase and Prisma, the project has a website (admin) and a mobile app with expo, setting up the website was pretty straightforward and easy, but now trying to set up the app I realize I can't use supabase client to query, I do not have access to query anything, I've followed this issue https://github.com/supabase/supabase/issues/3415 because I was getting same error, I was able to bypass the access to the db, but now I don't have access to any of the tables
This is the project I'm working on
This is a test where I created a new project & table, I guess I'm missing all the "anon" grantee? I don't know how these can be restored though
o
Hi so if i'm getting your issue right, you're trying to insert datas in the postgres database using Supabase, and you get a message
Copy code
error: permission denied for table test
Is it right? Or did i miss something?
j
Yes, I was initially getting the error permission denied for schema public, but I ran some of the commands suggested on the link I shared and somehow they worked for the schema access but not for tables
o
Are you using the selfhost version of Supabase?
j
Hmmm, I don't think so, tbh I don't know what that means 😄