"Balazs Wellisch" <balazs(at)bwellisch(dot)com> writes:
> UPDATE pg_shadow SET usesuper = true WHERE usename = 'postgres';
> ERROR: pg_shadow: Permission denied.
Hmm. I forgot that you'd need usecatupd privilege to do that.
> Any other suggestions? I appreciate your help.
I think you may be stuck :-( ... unless you want to risk editing the
pg_shadow file with a binary-file editor.
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Søren Neigaard||Date: 2002-07-17 20:43:42|
|Subject: How do I only allow one group access to my database|
|Previous:||From: Balazs Wellisch||Date: 2002-07-17 17:58:17|
|Subject: Re: Help: Dumb newbie locked himself out! |