Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# 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

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine

Copyright © 1994-2024. Cloud Software Group, Inc. All Rights Reserved.