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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: alban <alban_dot_minassian_(at)wanadoo(dot)fr>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: 7.3 : how add user when last user have lost 'createuser' option
Date: 2003-11-08 21:03:15
Message-ID: 200311082103.hA8L3Fe20121@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

alban wrote:
> 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 ?

Uh, you removed createuser permission from the postgres super-user. I
think that's why you are getting the failure. I think you have to
manually update pg_shadow to fix this, if it will allow that.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-11-08 21:15:03 Re: 7.3 : how add user when last user have lost 'createuser' option
Previous Message Bruce Momjian 2003-11-08 21:01:06 Re: 7.3 how remove password valid until