SQL*Plus® User's Guide and Reference
ContentsOpens a new window
Opens a new window
Page 51 of 82

PASSWORD

Syntax

PASSW[ORD] [username]

where username specifies the user. If omitted, username defaults to the current user.

Enables you to change a password without echoing it on an input device.

Usage

To change the password of another user, you must have been granted the appropriate privilege. See CONNECTOpens a new window for more information about changing your password.

Examples

If you want to change your current password, enter

PASSWORD
Changing password for your_password
Old password: your_password
New password: new_password
Retype new password: new_password
Password changed

If you are logged on as a DBA, and want to change the password for user johnw (currently identified by johnwpass) to johnwnewpass

PASSWORD johnw
Changing password for johnw
New password: johnwnewpass
Retype new password: johnwnewpass
Password changed

Passwords are not echoed to the screen, they are shown here for your convenience.