Re: [GENERAL] alter user to change user's password returns pg_shadow: Permission denied.

2001-07-29 Thread Tom Lane
Wayne Johnson <[EMAIL PROTECTED]> writes: > According to the Postgresql manual, a user can alter their own > password. When I try: > alter user "test" with password ""; > Where test is the user id signed in with, I get the error: > ERROR: pg_shadow: Permission denied. Works for me. What ve

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

2001-07-29 Thread Wayne Johnson
According to the Postgresql manual, a user can alter their own password. When I try: alter user "test" with password ""; Where test is the user id signed in with, I get the error: ERROR: pg_shadow: Permission denied. What am I overlooking? Tia, ---(end of broadcast