How to Change Password of Individual Account in Oracle Database without DBA?

A developer or any individual can change his or her password on their own without any DBA help.

Right click on connection -> Reset Password. Then you see a pop-up asking for current password and new password. Enter the required details press “OK”.

How to Change Password of Individual Account in Oracle Database without DBA?

If you forget your current password and having established connection in SQL Developer/Toad etc. simply use “ALTER USER” statement to change the password. Login to database using SQLPLUS/SQL Developer/Toad etc. simply use below statement to change the password.

ALTER USER “user_id” IDENTIFIED BY “passwd”;

SQL>
SQL> alter user SCOTT identified by tiger;

User altered.

SQL>

Leave a comment