Oracle / PLSQL: Change a user's password in Oracle

Question: How do I change the password for a user in Oracle?

Answer: To change a user's password in Oracle, you need to execute the alter user command.

Syntax

The syntax for changing a password in Oracle is:

ALTER USER <strong>user_name</strong> IDENTIFIED BY <strong>new_password</strong>;

Parameters or Arguments

user_name

The user whose password you wish to change.

new_password

The new password to assign.

Example

Let's look at an example of how to change a password for a user in Oracle/PLSQL.

For example:

ALTER USER smithj IDENTIFIED BY autumn;

This example would change the password for the user named smithj and set the new password to autumn.