How to Change password without showing the actual password on screen?

Hello friends, today we are going to discuss how to change the oracle user password without showing the actual PASSWORD on the screen. There is two way one is with ALTER command another one is PASSWORD keyword. But in the case of alter command, the password will show on screen, and in the case of PASSWORD, the keyword did not.

In my case, the username is the hero. If I change the credential of the hero user with the ALTER command the password will be showing on the screen like below.

SQL> alter user hero identified by heropass; 

Change password without showing

Now I’m going to use the password keyword to change user credentials on SQL prompt without showing, Execute below command.

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

Read - How to get DDL of users and roles?

Connect with me on:

Instagram: https://www.instagram.com/shripaldba
Linkedin: https://www.linkedin.com/in/shripal-singh
Twitter: https://twitter.com/ocptechnology
Facebook: https://www.facebook.com/ocptechnology
YouTube:https://www.youtube.com/ocptechnology