SQL*Plus User's Guide and Reference
Release 8.1.5

A66736-01

Library

Product

Contents

Index

Prev Up Next

Command Reference, 30 of 52


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

Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index