Hello friends today we are going to discuses how to change oracle user password without showing actual PASSWORD on the screen. There is two way one is with ALTER command another one is PASSWORD keyword. But in case of alter command the password will show on screen and in case of PASSWORD keyword did not.
In my case the username is hero
If i change the credential of hero user with ALTER command the password will be showing on screen like below.
SQL> alter user hero identified by heropass;
Now i’m going to use password keyword to change user credential on SQL prompt without showing, Execute below command.
You Can subscribe YouTube channel
SQL> password Changing password for hero Old password: New password: Retype new password: Password changed