alter user to change user's password returns pg_shadow: Permission denied.

From: Wayne Johnson <wdtj(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: alter user to change user's password returns pg_shadow: Permission denied.
Date: 2001-07-30 02:22:12
Message-ID: 3B64C4D4.2482B670@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

According to the Postgresql manual, a user can alter their own
password. When I try:
alter user "test" with password "zzzz";
Where test is the user id signed in with, I get the error:
ERROR: pg_shadow: Permission denied.

What am I overlooking?

Tia,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-07-30 03:34:21 Re: alter user to change user's password returns pg_shadow: Permission denied.
Previous Message Tom Lane 2001-07-29 23:55:44 Re: Re: "Oracle's ROWNUM"