From: | "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com> |
---|---|
To: | "Kevin Murphy" <murphy2(at)speakeasy(dot)net>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Permission denied to create database |
Date: | 2007-05-04 13:20:06 |
Message-ID: | 012401c78e4e$f29edfc0$170211ac@LIONKING.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Can u tell us what are the role privilages granted to user "joe"
May be you r missing with the create database privilage to user joe
With Regards
Ashish....
----- Original Message -----
From: "Kevin Murphy" <murphy2(at)speakeasy(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Friday, May 04, 2007 6:36 PM
Subject: [GENERAL] Permission denied to create database
> Sleep deprived and surely doing something stupid here; I can't seem to
> confer the ability to create databases on a regular user. I always get
> "permission denied to create database". One note: template1 has had some
> C functions added to it. Could that be related to the problem?
>
> $ createdb -U joe joejunkdb
> createdb: database creation failed: ERROR: permission denied to create
> database
>
> $ 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
>
> joe=> \db+
> List of tablespaces
> Name | Owner | Location | Access privileges
> | Description
> ------------+----------+----------+----------------------------------------+-------------
> pg_default | postgres | | {postgres=C/postgres,joe=C/postgres} |
> pg_global | postgres | |
> |
>
> joe=> \l+
> List of databases
> Name | Owner | Encoding | Tablespace |
> Description -----------+----------+----------+------------+---------------------------
> ...
> template1 | postgres | UTF8 | pg_default | Default template database
>
> For some reason, I haven't succeeded by reading the docs and googling.
>
> Thanks for jarring my memory,
> Kevin Murphy
> PostgreSQL 8.2.4
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-05-04 13:50:23 | Re: cant get pg_dump/pg_restore to behave |
Previous Message | Richard Huxton | 2007-05-04 13:15:01 | Re: Permission denied to create database |