Installation guide

PegaRULES Process Commander Installation Guide v6.1 SP2

User Privileges for the Oracle Database

Set the user account for the Process Commander database user with the default RESOURCE

and CONNECT roles with all corresponding system privileges granted. In particular, be sure that

the user has the Create View system privilege.

Note: On the Oracle 10g HTML-based Enterprise Manager console there are

separate tabs for setting the user’s roles and system privileges. When editing

the properties for the Pega user, be sure to go to the Roles tab to set the

RESOURCE and CONNECT roles, and then to the System Privileges tab to

set the Create View system privilege.

Important: Do not grant DBA access to the user, as this may cause

problems with the installation.

User Privileges for the UDB Database

Create a user account for the Process Commander database user with at least SYSADM

privileges.

Create the Schema in Process Commander Database

Before you load the initial Process Commander rules into the database in Steps 4-9 below, you

must create the database schema that defines the data objects (tables, indexes, views, triggers

and procedures) required by Process Commander.

You can create the schema in two ways:

1. In the Install and Upgrade Assistant user interface, you can select the

Create Schema option. The Assistant then creates a default schema in the

database automatically before loading the Rulebase.

If you want the Assistant to create the schema, skip the following section

“Using a SQL Script to Create the Schema”, and continue with the Assistant

as described in Steps 4-9 below.

2. Your database administrator (DBA), or someone with appropriate

permissions, can run a SQL script, provided by Pegasystems, to create the

schema in your Process Commander database. Process Commander V6.1

SP2 includes SQL scripts for each supported database: mssql, oracle

(oracledate), and udb, for example, oracledate_install_6.1SP2.sql.

Running the SQL script allows you to review and, if necessary, customize the

schema for your environment.

To create the schema in the database using the SQL script, follow the

procedure described in the next section.