Re: User privileges-verification required

Peter Eisentraut <peter_e@gmx.net>

From: Peter Eisentraut <peter_e@gmx.net>
To: pgsql-hackers@postgresql.org
Cc: "Nauman Naeem" <nauman.naeem@gmail.com>
Date: 2006-02-24T13:42:55Z
Lists: 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/