|SQL*Plus User's Guide and Reference
Command Reference, 30 of 52
Allows you to change a password without echoing the password on an input device.
Refer to the following for a description of the clause or term:
To change the password of another user, you must have been granted the appropriate privilege.
For more information about changing your password, see the CONNECT command in this chapter.
Suppose you are logged on as scott/tiger, and want to change the password to tigertiger
SQL> passw Changing password for scott Old password: tiger New password: tigertiger Retype new password: tigertiger Password changed
Suppose you are logged on as a DBA, and want to change the password for user usera (currently identified by passa) to passusera