IBM Security Identity Governance and Intelligence, Version 5.2

Changing the default password for the database schemas

This section explains how to change the default password (ideas) that grants access to the schemas of the IBM® Security Identity Governance and Intelligence database.

About this task

In the Identity Governance and Intelligence database, the password required to access the database schemas is defined by the scripts that install the schemas. See Configuring the Oracle server and Configuring the DB2 server. The default password, provided out-of-the-box, is ideas. To change the default password from ideas to another value, complete the steps in the procedure.

Attention: Complete the procedure before you start the schema installation steps.

Procedure

On both Oracle and DB2:

Unpack the following compressed file from the product package image or DVD and unzip the subdirectory corresponding to your database (Oracle or DB2) into a directory of your choice in your database server. For example, SCRIPT:
```
SEC_IDNTY_GVN_INTL_xxx_V5.2_DT_IN_.zip
```
Where xxx can be CMP, ANL, LFC, or IEE, depending on which product media type that includes the IBM Security Identity Governance and Intelligence V5.2 Database Installation Scripts file you are using.
Open the following file with an editor:
UNIX

SCRIPT/DB_INSTALLATION/IGI_5_2_0_INSTALLATION/00-COMMON/01-COMMON.sql

Windows

SCRIPT\DB_INSTALLATION\IGI_5_2_0_INSTALLATION\00-COMMON\01-COMMON.sql

In the file, find this section:

On Oracle:

-----------------------------------------------------------
-- DEFAULT PASS VALUES                                   --
-----------------------------------------------------------
DEFINE IDEAS_SCHEMA_DEF_PASS = '"ideas"'

On DB2:

-----------------------------------------------------------
-- DEFAULT PASS VALUES                                   --
-----------------------------------------------------------
DEFINE IDEAS_SCHEMA_DEF_PASS = '''ideas'''

Replace ideas with the new password, keeping the original database-dependent semantics; that is:
- '"new_password"' (new password enclosed within double quotes enclosed within single quotes) on Oracle
- '''new_password''' (new password enclosed within sets of three single quotes) on DB2

On DB2 only, continue as follows:

Open the following file with an editor:
UNIX

SCRIPT/__FOR_DBAs__/unix_create_users.sh

Windows

SCRIPT\__FOR_DBAs__\win_create_users.bat
In the file, find the ideas string and replace it with the value used in the previous step (without quotation marks).

Results

The password is now changed.