Change User Password in Oracle

In the world of technology, we use “USERNAME and PASSWORD “ multiple time in a day. As per nature, rule “CHANGE “is a must.  Oracle Database also provides the option to change user’s password. The only superuser has a privilege to change the password.

Let’s have look at the steps which we use to change the password.

The user can able to change the password by login

#sqlplus username_1@service_name_1

SQL> password
Old password:
New password:
Retype new password:
Password Changed
SQL>

Change Password as sysdba

SQL> alter user <username> identified by <password>;
User altered.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp