Recently I faced an issue when I wanted to delete an existing database in an application deployed in heroku and create a new one.
I tried using
heroku run rake db:drop
I got an error saying “USER does not have connect privilidges”
The way to solve it is
This logs in to your database and then type:
drop schema public cascade; create schema public;
After this exit the prompt and type:
heroku rake db:migrate:reset
Hope it helps.