[GENERAL] User authorization

2005-06-28 Thread Wayne Johnson
Something like the sticky bit in a directory on UNIX. Thanks for a great product. --- Wayne Johnson, | There are two kinds of people: Those 3943 Penn Ave. N. | who say to God, "Thy will be done," Minneapolis, MN 55412-1908 | and those to whom God says, "A

[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