ALTER USER SQL - Language Statements ALTER USER Modifies user account information 1999-07-20 ALTER USER username [ WITH PASSWORD 'password' ] [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ] [ VALID UNTIL 'abstime' ] 1998-09-08 username The name of the user whose details are to be altered. password The new password to be used for this account. CREATEDB NOCREATEDB These clauses define a user's ability to create databases. If CREATEDB is specified, the user being defined will be allowed to create his own databases. Using NOCREATEDB will deny a user the ability to create databases. CREATEUSER NOCREATEUSER These clauses determine whether a user will be permitted to create new users himself. This option will also make the user a superuser who can override all access restrictions. abstime The date (and, optionally, the time) at which this user's password is to expire. 1998-09-08 ALTER USER Message returned if the alteration was successful. ERROR: ALTER USER: user "username" does not exist Error message returned if the specified user is not known to the database. 1998-09-08 ALTER USER is used to change the attributes of a user's Postgres account. Only a database superuser can change privileges and password expiration with this command. Ordinary users can only change their own password. Use to create a new user and to remove a user. 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 authorization 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; 1998-09-08 There is no ALTER USER statement in SQL92. The standard leaves the definition of users to the implementation.