PASSWORD

Purpose

Allows you to change a password without echoing the password on an input device.

Syntax

PASSW[ORD] [username]

Terms and Clauses

Refer to the following for a description of the clause or term:

username

Specifies the user. If you do not specify a username, username defaults to the current user.

Usage Notes

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.

Example

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

SQL> passw usera
Changing password for usera
New password: passusera
Retype new password: passusera
Password changed