Re: can't alter user with the postgres user

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Katy Earl <khaetee(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: can't alter user with the postgres user
Date: 2003-05-13 20:43:53
Message-ID: 200305131343.53764.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message M. Bastin 2003-05-13 20:53:31 Re: Multilingual database
Previous Message Josh Berkus 2003-05-13 20:36:13 Re: Advisable to move SQL from PHP to functions?