Re: User privileges-verification required
Nauman Naeem <nauman.naeem@gmail.com>
From: "Nauman Naeem" <nauman.naeem@gmail.com>
To: nauman.naeem@gmail.com
Cc: pgsql-hackers@postgresql.org
Date: 2006-02-24T14:34:11Z
Lists: pgsql-hackers
I tried the single-user mode option and it worked, thanks! but, don't you people think that we should provide this privilege in multi-user mode as well.In accordence to my second point. On 2/24/06, Peter Eisentraut <peter_e@gmx.net> wrote: > 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/ >