tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment
Share this page:

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 user_name IDENTIFIED BY new_password;

Parameters or Arguments

user_name is the user whose password you wish to change.

new_password is the new password to assign.

Example

If you wanted to reset the password for a user named smithj, and you wanted to set the new password to autumn, you would run the following command:

ALTER USER smithj IDENTIFIED BY autumn;