IBM FileNet P8, Version 5.2.1            

Creating database authentication aliases

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.
  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 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.
  3. 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 properties
    Database 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
  4. 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.
    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.


Last updated: October 2015
bpfbm008.htm

© Copyright IBM Corporation 2015.