ERROR: permission denied for table schema_migrations

Hi my applicaiton uses the auth schema as part of our Prisma definition (so that the

users

users

table could be pulled alongside a separate

UserProfile

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

schema_migrations

table in the

auth

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

postgres

role?

Supabase•5mo ago•

12 replies

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

users

table could be pulled alongside a separate

UserProfile

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

schema_migrations

table in the

auth

auth

postgres

postgres

role?

ERROR: permission denied for table schema_migrations

Similar Threads

ERROR: permission denied for table schema_migrations

Similar Threads

Similar Threads

Similar Threads