iProcess Engine DB User Name

Database Connection and Account Details Menu

Description

The name of the Oracle user (for Oracle users) or the UNIX account (for DB2 users) that the iProcess Engine uses to access the iProcess Engine database schema. This user has the iProcess Engine uses to access the iProcess Engine database schema with the REFERENCES, SELECT, DELETE, and UPDATE permissions

Note 

You can either create this account before you run the installer, let the installer create it for you, or create it after you have run the installer. See How Do I Decide Which Oracle Database Creation Method to Use.

Value

 

Installation Type

New Installation

Upgrade Installation

Value

Oracle

An Oracle account name that:

—is between 1 and 30 characters long.

—contains only lowercase, alphanumeric, and underscore (_) characters.

—has a leading alphanumeric character.

The name of the existing iProcess Engine database user account, taken from the third entry (after the second backslash character) on line 9 of the $SWDIR/etc/staffpms file.

You cannot change this value.

DB2

A UNIX account name that:

—is between 1 and 8 characters long.

—contains only alphanumeric and underscore (_) characters.

—has a leading alphanumeric character.

Default Value

swuser

 

Node Cluster

If you are installing a slave server, the account name used must be the same name used on the master server.

 

Notes

The Oracle account name used must have the following permission grants:

• connect
• resource
• create table
• AQ_ADMINISTRATOR_ROLE
• execute on dbms_aq

Warning 

If you create this Oracle account before running the installer (see Creating Oracle Accounts and Tablespaces), you must also associate the account with the data tablespace (see Data Tablespace Name) and temporary tablespace (see Temporary Tablespace Name) to be used by the iProcess Engine.

If the account name you specify does not already exist, you are prompted to create it when you continue from the Oracle Database Connection and Account Details Menu. For example:

iProcess Engine DB Schema Owner (swpro001) does not exist.
Create user (Y/N - default N): Y

If you enter:

• Y, the user is flagged for creation and the new username is displayed in the menu.
• N, the old name is shown.

Note 

The account is not actually created until the installer performs the installation. See step 7 in Installing TIBCO iProcess Engine in Console Mode.

Control File Keyword

IPEI_DBUSRNAME