ALTER USER username [ WITH PASSWORD password ] [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ] [ IN GROUP groupname [, ...] ] [ VALID UNTIL 'abstime' ]
Refer to CREATE USER for a detailed description of each clause.
The Postgres account name of the user whose details are to be altered.
The new password to be used for this account.
The name of an access group into which this account is to be put.
The date (and, optionally, the time) at which this user's access is to be terminated.
ALTER USER is used to change the attributes of a user's Postgres account. Please note that it is not possible to alter a user's "usesysid" via the alter user statement. Also, it is only possible for the Postgres user or any user with read and modify permissions on "pg_shadow" to alter user passwords.
If any of the clauses of the alter user statement are omitted, the corresponding value in the "pg_shadow" table is left unchanged.
Change a user password
ALTER USER davide WITH PASSWORD hu8jmn3;
Change a user's valid until date
ALTER USER manuel VALID UNTIL 'Jan 31 2030';
Change a user's valid until date, specifying that his authorisation should expire at midday on 4th May 1998 using the time zone which is one hour ahead of UTC
ALTER USER chris VALID UNTIL 'May 4 12:00:00 1998 +1';
Give a user the ability to create other users and new databases.
ALTER USER miriam CREATEUSER CREATEDB;
Place a user in two groups
ALTER USER miriam IN GROUP sales, payroll;