Re: User privileges-verification required - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: User privileges-verification required
Date
Msg-id 200602241442.56948.peter_e@gmx.net
Whole thread Raw
In response to User privileges-verification required  ("Nauman Naeem" <nauman.naeem@gmail.com>)
Responses Re: User privileges-verification required
List pgsql-hackers
Am Freitag, 24. Februar 2006 14:25 schrieb Nauman Naeem:
> In case I have only one user in my database who is also the DBSystem
> (who carries out initdb), user then if that user takes away his
> "createuser" privileges, he is unable to grant himself that privilege
> again or grant that privilege to any other user that he creates.This
> creates quite a fix since you end up with no superusers, nor a way to
> create any other superusers.

Shut down the server, start in single-user mode, then you can fix it.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-hackers by date:

Previous
From: "Nauman Naeem"
Date:
Subject: User privileges-verification required
Next
From: "Nauman Naeem"
Date:
Subject: Re: User privileges-verification required