IBM Security Identity Governance and Intelligence, Version 5.2.3.1

Changing the database password after installation

You can change the password of the Identity Governance and Intelligence database anytime after you have installed the schemas. This information applies if you use an external DB2 or Oracle database server. If you use the internal PostgreSQL database, see Changing the Postgres database password.

About this task

You can change the Identity Governance and Intelligence database password anytime that you deem necessary when Identity Governance and Intelligence is in operation.

Do not use any of these special characters in the password:

$ ~ @ # ( ) - _ { } .

Attention: When you upgrade or install a fix pack, it is your responsibility to change the default password in the SQL installation scripts. For example, oracle\upgrade-fixpack\IGI_5.2.2_CUMULATIVE\COMMON\01-COMMON.sql contains the following line:

DEFINE IDEAS_SCHEMA_DEF_PASS = '"ideas"'

In this line, you must replace the default password with your custom password.

Procedure

Refer to the DB2 or Oracle documentation to change the password of a DB user. In the database, you must set the same password for every Identity Governance and Intelligence schema user. The schema users are listed in the next table.

Table 1. List of Identity Governance and Intelligence schema users
Schema user in Oracle	Schema user in DB2
AA	aa
IDEAS	iga
IDEAS_CONNECTOR	igaconn
IDEAS_REPORT	rep
AA_ADMIN	aaadm
AA_CORE	aacore
IGA_ADMIN	igaadm
IGA_CORE	igacore
CCS_CORE	ccscore
IGA_REPORT_ADMIN	repadm
IGA_REPORT_CORE	repcore
IGA_SERVICE	igaserv
ITIMUSER	itimuser
IGA_QUARTZ	igaqrz

After you changed the passwords in the database, stop Identity Governance and Intelligence.
Use the virtual appliance to reconfigure the database with the new password, as documented in Managing the database server configuration.
Restart Identity Governance and Intelligence.