Unable to change owner of table
Hello! I have a Prisma ORM issue where I need to ignore certain tables from my introspection and migrations. There is currently a feature request for this as it is not directly available, however, the current workaround is to have 2 roles, and only grant ownership of the tables Prisma should manage to the prisma user.
I have created the prisma user, however, all our tables were created using the older user. I try to run
I have created the prisma user, however, all our tables were created using the older user. I try to run
ALTER TABLE "Account" OWNER TO prisma; but I get an error that says must be able to SET ROLE "prisma". I don't see anything in the documentation on this so is it not possible to accomplish what I am trying to do here, short of blowing away all our data by dropping the tables and recreating them with the proper user?
