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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org