Use the following steps to create authentication aliases
to connect to the workflow system and the common base event adapter
databases.
To query a workflow system, the default schema of the workflow
system database user must be the same as the schema of the workflow
system that is being queried. For a regular workflow system, you can
find the database schema name in the object store node in the Administration Console for Content Platform Engine. For a legacy workflow
system, you can find the schema name in the properties tab of the
isolated region in the legacy workflow system node in Administration Console for Content Platform Engine.
- In the Administrative Console menu, select .
- Create an authentication alias for use by the BPM common
base event adapter for WebSphere® to
connect to the workflow system. The user that is referenced by this
alias must have privileges for you to use the BPM common base event
adapter to query the workflow event log views and to update the VWPAEventState
table.
- Click New to create an alias and
specify the following information:
- Alias
- User (the workflow system database user)
- Password
- Description (optional)
Table 1. Database user name propertiesDatabase |
Database user name properties |
SQL Server |
The user must have the following database privileges: - db_datawriter
- db_datareader
- public
|
Oracle |
The user must have the following database privileges:- SELECT privilege on all workflow system database tables and views
- SELECT, INSERT, and UPDATE privileges on the VWPAEventStateregion
number database tables
- SELECT ANY DICTIONARY privilege
You can use the following SQL commands to create a user, if necessary,
and grant the required privileges. GRANT CREATE SESSION to
&PEDatabaseUserName IDENTIFIED by
&Password; GRANT SELECT ANY TABLE to
&&PEDatabaseUserName; GRANT SELECT,
INSERT, UPDATE on
&PEOwnerName..vwpaeventstate to
&&PEDatabaseUserName; rem ALTER USER
&&PEDatabaseUserName DEFAULT TABLESPACE
VWDATA_TS; GRANT CONNECT, RESOURCE
to &&PEDatabaseUserName; GRANT SELECT
ANY DICTIONARY to &&PEDatabaseUserName;
where: PEDatabaseUserName is
the user name you are entering for this property. Password is
the password associated with this user. PEOwnerName is
the name of the database user who owns the workflow system database
tables. Tip: The workflow system database must be initialized
before running these commands.
|
DB2® |
The user must have the following database privileges: - SELECT privilege on all workflow system database tables and views
- SELECT, INSERT, and UPDATE privileges on the VWPAEventStateregion
number database tables
|
- Create an authentication alias for use by the BPM common
base event adapter for WebSphere to
connect to the BPMSTATE database. The user referenced by this alias
must have privileges for the common base event adapter to update the
tables within the BPMSTATE database.
- Click New to create an alias
and specify the following information:
- Alias
- User (BPMSTATE database user)
- Password (BPMSTATE database user password)
- Description (optional)
- Click OK.
- Click Save to Master Configuration,
and then click Save.