Why am I seeing "User does not have CONNECT privilege" error with Heroku Postgres on Review Apps?

Issue

User does not have CONNECT privilege is shown in the build logs or postdeploy output.

Resolution

We typically see CONNECT privilege issues where applications try to create databases as part of db:setup, as the user provided does not have permission to create or drop databases.

For Rails apps you should look to use db:schema:load, db:structure:load or db:migrate instead of db:setup.

Ask on Stack Overflow

Engage with a community of passionate experts to get the answers you need

Ask on Stack Overflow

Heroku Support

Create a support ticket and our support experts will get back to you

Contact Heroku Support