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

Bruce Momjian <[EMAIL PROTECTED]> writes: > alban wrote: >> i have execute >> ALTER USER postgres WITH NOCREATEUSER; > Uh, you removed createuser permission from the postgres super-user. That was a really bad move :-( If you have no superusers left, I think your only option is to shut down the p

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

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

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

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 ---(end of broadcast)---