ALTER USER

3.3.7 ALTER USER

Name

ALTER USER -- change a database user account

Synopsis

ALTER USER name IDENTIFIED BY password

Description

ALTER USER is used to change the password of a Postgres Plus Advanced Server user account. A database superuser or a user with the CREATEROLE privilege can use this command. Ordinary users can also use this command to change their own password.

Parameters

name

The name of the user whose attributes are to be altered.

password

The new password to be used for this account.

Examples

Change a user password:

ALTER USER john IDENTIFIED BY xyz;