Re: [ADMIN] password change...

> Hmmm hi all,
>
> Alright I've GOT to be blind (knowing me it's a good possibility)... but
> I have a need to allow postgresql users to be able to change their own
> password, but if they don't have access to the pg_shadow or update user
> command how to I grant them this privilage and/or what command would
> they run....?

$ psql -q template1
template1=# \h ALTER USER
Command: ALTER USER
Description: change a database user account
Syntax:
ALTER USER username [ [ WITH ] option [ ... ] ]

where option can be:

[ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
| CREATEDB | NOCREATEDB
| CREATEUSER | NOCREATEUSER
| VALID UNTIL 'abstime'

--
Sean Chittenden