Change Password via sqlplus and cause it to prompt for the new password
441662Nov 7 2006 — edited Nov 7 2006How can a user change their own Oracle database password without help from the DBA?
The idea is to have the password not echoed back to the screen.
The only thing I could think of was to do this:
Log in via sqlplus:
Username: someuser@somedb.oracle
Password:
Connected to:
Oracle...
SQL> ALTER USER someuser PASSWORD EXPIRE;
User Altered.
SQL>DISCONNECT;
Disconnected from...
SQL>CONNECT;
Username: someuser@somedb.oracle
Password:
Changing Password for SOMEUSER
New Password:
Retype New Password:
Connected.
Of course, if the password was expired or expired with a grace period, then the user would be prompted automatically to enter a new password.
Is there an easier solution for Windows users?