Changing the database schema users password

Explains how to change the database schema users password in the database server.

Procedure

On the oracle database host, log in as oracle user.
Log in to SQL*Plus by entering the following command:
```
$ sqlplus / as sysdba
```
Run the following command to list the schema users in the database:
```
$ select username from dba_users where username like 'PV%';
```
Refer to Table 1 to view the Tivoli® Netcool® Performance Manager database schema users list.

Run the following command to change the database schema password:

ALTER USER <USERNAME> IDENTIFIED BY <PASSWORD>;

For example:

ALTER USER PV_ADMIN IDENTIFIED BY "Telco123";

Run the following command to connect to the DB2 database:

clpplus -nw <ADMIN_USER>/<ADMIN_PASSWORD>@localhost:60000/<SID>

For example:

$ clpplus -nw PV_ADMIN/PV@localhost:60000/PV

Run the following command to list the schema users in the database:
```
$ select userid from db2auth.users;
```
Refer to Table 1 to view the Tivoli Netcool Performance Manager database schema users list.
Run the following command to change the database schema password:
```
$ db2 "CONNECT TO <DATABASE> USER <USERNAME> USING <PASSWORD> NEW <new_password> 
CONFIRM <new_password>"
```
Where:
- <DATABASE> - database name
- <userid> - database schema user
- <PASSWORD> - current database schema user password
- <new_password> - new database schema user password
For example:
```
$ db2 "connect to PV user PV_GUI using PV NEW PV1 CONFIRM PV1" 
```