Postgres Pro
Downloads
Home   >   mailing lists

Re: can't alter user with the postgres user - Mailing list pgsql-novice

From Josh Berkus
Subject Re: can't alter user with the postgres user
Date
Msg-id 200305131343.53764.josh@agliodbs.com
Whole thread Raw
In response to can't alter user with the postgres user  (Katy Earl <khaetee@yahoo.com>)
Responses Re: can't alter user with the postgres user
List pgsql-novice
Tree view 
Katy,

> 2) CREATE USER ...:
> Shall the new user be allowed to create databases?
> (y/n) y
> Shall the new user be allowed to create more new
> users? (y/n) y
> ERROR: CREATE USER: permission denied.
> createuser: creation of 'carl' failed.

What about doing it from psql?

Also from psql:

SELECT * FROM pg_user;

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Advisable to move SQL from PHP to functions?
Next
From: "M. Bastin"
Date:
Subject: Re: Multilingual database