How to change the password for an Oracle's Userid?

Technote (FAQ)
Problem
Change password for an Oracle's Userid
Solution
To change the password for an Oracle's Userid, perform the followings:

1. Logon to Oracle database (via any of Oracle's Tools, e.g. SQL*Plus) using an account with DBA prvilege (e.g. SYSTEM) or using the Userid whose password that is going to be changed. For example, if you want to change the password for userid "EJSADMIN", you can logon to Oracle using the "SYSTEM" or the "EJSADMIN" userid.

2. Once you are logged on to Oracle database, issue the following command:

ALTER USER <userid> IDENTIFIED BY <NewPassword>

For example:

ALTER USER ejsadmin IDENTIFIED BY anything












Document Information

Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server
Operating system(s): Multi-Platform
Software version: 3.5, 4.0.1, 3.0
Reference #: 1047488
IBM Group: Software Group
Modified date: 2002-11-06