Changing a User's Password

Change the password of another user.

Prerequisites

Requires the CHANGE PASSWORD system privilege.

Task

You can set up password rules (MIN_PASSWORD_LENGTH option) and verify that any new password assigned complies with them (VERIFY_PASSWORD_FUNCTION option). For example, you might require that passwords must include one digit or cannot be the user ID.

To change a user password, execute:

ALTER USER user_ID
IDENTIFIED BY password

Example:

This statement assigns the new password P&ssW0rd to user M_Smith:

ALTER USER M_Smith IDENTIFIED BY P&ssW0rd