How do I give a user account in PostgreSQL the ability to create and drop databases? Is there a way to do this with
It's done with
To drop a database, either you're superuser (which can be granted with
First, you have to login as postgres user:
After entering new password for postgres user (special kind of user on PostgreSQL), you are now logged in as postgres and you can grant permission to other users. Let's say you have user named user1. To grant him ability to create and drop databases, you have to write (as postgres user):
Hope this helps...