Got this error Detail: User does not have CONNECT privilege. after using Prisma for 2 months and it is not going away, the only way to get rid of this is to delete the database and add a new database. Moreover, resetting the database doesn't help either. This issue is prevalent for a long time https://github.com/dpetrick/prisma-heroku/issues/1 and did not get the solution yet. I hope to get a reply back from the Prisma team.

Hey, Looks like you haven't attached the credentials to the heroku app you have created. Heroku rotates the credentials, so that is why Prisma is unable to connect anymore. I think we do this automatically in the integration, can you please try using the integration instead of the manual setup?

I am aware that Heroku rotates the credentials but that is not the case here I am entering the correct credentials. And can you please enlighten me about the integration and the manual step. I am just writing the docker-compose.yml file and running

docker-compose up

I have the same problem. My docker-compose.yml information matches the credentials of my heroku server. Checked the logs for my docker container and I had the error: "Detail: User does not have CONNECT privilege." I also checked security on my pgAdmin page and saw that my user does have connection privilege.

The issue got resolved for me when I destroyed the database and created a new one. Apparently, this is not possible when the app is in production.