Using Change a user’s password in Oracle in Oracle

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

Answer: To trade 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 user_name IDENTIFIED BY new_password;

Parameters or Arguments

user_name The consumer whose password you desire to change. new_password The new password to assign.

Example

Let’s appear at an instance of how to exchange a password for a person in Oracle/PLSQL.

For example:

ALTER USER smithj IDENTIFIED BY autumn;

This instance would trade the password for the user named smithj and set the new password to autumn.