Re: Permission denied to create database

From: "Mikko Partio" <dun(at)haisuli(dot)net>
To: "Kevin Murphy" <murphy2(at)speakeasy(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Permission denied to create database
Date: 2007-05-04 15:40:55
Message-ID: 38822.2001:14b8:1b0:0:216:d4ff:fe03:2af0.1178293255.squirrel@haisuli.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


>
> $ sudo -u postgres psql -c "grant all on tablespace pg_default to joe"
> Password:
> GRANT
>
> $ createdb -U joe joejunkdb
> createdb: database creation failed: ERROR: permission denied to create
> database
>

How about ALTER ROLE joe CREATEDB

Regards

MP

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hakan Kocaman 2007-05-04 15:46:37 Re: Stored procedure
Previous Message Thorsten Kraus 2007-05-04 15:36:20 Re: Stored procedure