How To Change User Password In Oracle Database

Onur ARDAHANLI

2 years ago

In today’s article, we will be cover about How to Change User Password in Oracle Database.

The person who will change the password must have “ALTER USER” system authority.

The password is case sensitive.

1. From SQL*PLUS:

SQL> passw BURCU

1	SQL> passw BURCU

2. FROM TERMINAL or TOAD:

SQL> ALTER USER BURCU IDENTIFIED BY "BURCU";

1	SQL> ALTER USER BURCU IDENTIFIED BY "BURCU";

In addition, a user who forgot his password can reset his password and create a new password for himself.

In this case we use the following command.

What we need to pay attention to is that at least 5-6 characters of the password are not the same as the old password.

ALTER USER SDEMIRDOGEN IDENTIFIED BY "Changeme2" PASSWORD EXPIRE ACCOUNT UNLOCK;

1	ALTER USER SDEMIRDOGEN IDENTIFIED BY "Changeme2" PASSWORD EXPIRE ACCOUNT UNLOCK;