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
Connect with me on: