Re: [ADMIN] password change... - Mailing list pgsql-general

> 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