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