Before you do anything else, you should login as this user via psql or ROLE leo LOGIN PASSWORD 'lion!king' CREATEDB VALID UNTIL 'infinity'; The is the ability to define a role that doesn't allow its member roles to inherit its rights..