Postgres Plus Advanced Server Oracle Compatibility Developer's Guide :

Previous PageTable Of ContentsNext Page

3.3.2 ALTER ROLE

Name

ALTER ROLE -- change a database role

Synopsis

ALTER ROLE name IDENTIFIED BY password

Description

ALTER ROLE changes the password of a role. Only superusers or users with the CREATEROLE attribute can use this command. If the role to be altered has the SUPERUSER attribute, then only a superuser can give this command. Note that unless the role has the LOGIN attribute, the password serves no real purpose.

Parameters

name

The name of the role whose password is to be altered.

password

The role’s new password.

Notes

Use GRANT and REVOKE to change a role’s memberships.

Examples

To change a role’s password:

ALTER ROLE admins IDENTIFIED BY xyRP35z;

See Also

CREATE ROLE, DROP ROLE, GRANT, REVOKE, SET ROLE

Previous PageTable Of ContentsNext Page