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
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?2 Replies
deep-jade•2y ago
A user ran into something similar yesterday: https://discord.com/channels/1176467419317940276/1232187365288837152
I'm following up with the team on this.
@Duffmaster Flex are you a paying customer? If so, please use https://console.neon.tech/app/projects?modal=support and support can sort it out
FYI @Yanic
multiple-amethyst•2y ago
@Duffmaster Flex would you mind if I connect to your endpoint as admin and manually correct the issue for you?