8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » Misc » Here

Change Your Own Password in an Oracle Database

This article describes how to change the password for your own user in an Oracle database.

ALTER USER Command

Log on to the database as yourself, using any tool that can send SQL statements to the database.

CONN my_user/MyPassword123@orcl

Once connected, issue to the following ALTER USER command, specifying the new password.

ALTER USER my_user IDENTIFIED BY MyNewPassword123;

You don't need any additional privileges to change your own password. The same command can be used to change the password for another user, provided you have a privileged account.

SQL*Plus and SQLcl

As well as using the ALTER USER command, you can use the PASSWORD command from the SQL*Plus and SQLcl utilities. You will be prompted for your current password and the new password.

SQL> password
Changing password for MY_USER
Old password: ********
New password: ********
Retype new password: ********
Password changed
SQL>

SQL Developer

From SQL Developer, do the following.

TOAD

From TOAD, do the following.

Hope this helps. Regards Tim...

Back to the Top.