Richard Huxton wrote:
Kevin Murphy wrote:
Sleep deprived and surely doing something stupid here; I can't seem
to confer the ability to create databases on a regular user.
As a superuser: ALTER USER joe CREATEDB
Thanks, Richard and others who replied. I don't have to deal with
permissions very
>
> $ 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
---(end of
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 func
Kevin Murphy wrote:
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 pro
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
