BPM CBE Adaptor for WebSphere Business Monitor deployment
Step 3: Create database authentication aliases

Use the following steps to create authentication aliases to connect to the Process Engine and CBE Adaptor databases.

  1. In the Administrative Console menu, select Security > Global Security > JAAS Configuration > J2C Authentication data.
  2. Create an authentication alias for use by the BPM CBE Adaptor for WebSphere to connect to the Process Engine database. The user referenced by this alias must have privileges allowing the CBE Adaptor to query the Process Engine event log views and to update the VWPAEventState table.
  3. Click New to create an alias and specify the following information:
    1. Alias
    2. User (Process Engine database user)
    3. Password (Process Engine database user password)
    4. Description (optional)
       
    Database user name properties:
    SQL Server

    The user must have read and write privileges on the Process Engine database tables.

    You can create this Process Engine database user by running the following stored procedures in Microsoft SQL Server Enterprise Manager Query Analyzer.

    PE_createDbUsers '<PEDatabaseUserName>', '', '<PEDatabaseName>'
    sp_addrolemember 'db_datareader', '<PEDatabaseUserName>'
    sp_addrolemember 'db_datawriter', '<PEDatabaseUserName>'

    where:

    PEDatabaseUserName is the user name you are entering for this property.
    PEDatabaseName is the name of the Process Engine database.

    NOTE You can ignore errors from the first procedure regarding empty object or column names as well as being unable to create a maintenance user. The second and third commands assign standard SQL roles to the newly created user, giving the user read and write privileges on the Process Engine database tables.

    The new user is created with the default password of "filenet", which you must change.
     

    Oracle

    The user must have the following database privileges:

    • SELECT privilege on all Process Engine database tables and views
    • SELECT, INSERT, and UPDATE privileges on the vwpaeventstate database table
    • 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 password associated with this user.
    PEOwnerName is the name of the database user who owns the Process Engine tables.

    NOTE  The Process Engine database must be initialized before running these commands.
     

    DB2 Use the Process Engine runtime user (f_sw or its alias) or a database administrator account.
  4. Create an authentication alias for use by the BPM CBE Adaptor for WebSphere to connect to the BPMSTATE database. The user referenced by this alias must have privileges allowing the CBE Adaptor to update the tables within the BPMSTATE database.
    1. Click New to create an alias and specify the following information:
      • Alias
      • User (BPMSTATE database user)
      • Password (BPMSTATE database user password)
      • Description (optional)
    2. Click OK.
  5. Click Save to Master Configuration, and then click Save.