SupabaseS
Supabase•3mo ago
Raj

ERROR: permission denied for table schema_migrations

Hi my applicaiton uses the auth schema as part of our Prisma definition (so that the 
users
 table could be pulled alongside a separate UserProfile table w/ a join clause on the ID).

It looks like a change was made recently w/ Supabase that changed the auth permissions to the schema_migrations table in the 
auth
 schema, and is preventing us from pushing any schema changes to our DB even if that particular table/schema is not being affected. Do you guys know of a way to grant all privileges/access again for that table to the 
postgres
 role?
Was this page helpful?