7.3 : how add user when last user have lost 'createuser' option

From: alban <alban_dot_minassian_(at)wanadoo(dot)fr>
To: pgsql-sql(at)postgresql(dot)org
Subject: 7.3 : how add user when last user have lost 'createuser' option
Date: 2003-11-02 18:21:13
Message-ID: bo3e6a$4t7$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

i have execute
ALTER USER postgres WITH NOCREATEUSER;
it's work very well but now, i cant add, drop, alter user, alter group...

ALTER USER postgres WITH CREATEUSER;
--> ERROR : ALTER USER : permission denied

there is a solution ?

Thank
ALban

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mark Stosberg 2003-11-03 00:42:46 Re: A tricky sql-query...
Previous Message alban 2003-11-02 18:03:38 7.3 how remove password valid until