FileNet P8 Case Analyzer, Version 5.2.1   Database:  SQL          

Creating a Case Analyzer database user for SQL Server

Create a database user account that Case Analyzer uses to connect to SQL Server databases that contain the Case Analyzer store and the Case Analyzer OLAP database.

After you create the Content Platform Engine database user for SQL Server, you must create the Case Analyzer database administrator user. For more information about creating the database user for SQL Server, see Creating a Content Platform Engine database user for SQL Server.

  1. Create the following database account:
    Case Analyzer database user (SQL Server)
    Unique identifier
    ca_db_administrator
    Description
    The database accounts that Case Analyzer uses to access the SQL Server databases that contain the Case Analyzer store and the Case Analyzer OLAP database.
    ca_db_administrator must be a SQL Server account. It does not have to be an account in the configured directory service.
    Minimum required permissions
    In addition to the Content Platform Engine database user permissions, grant each ca_db_administrator the following permissions:
    • db_securityadmin
    • Bulk admin
    Add these accounts to the master database for SQL Server and grant the public role to each. When you complete the procedure to grant the permissions to participate in distributed transactions with the JDBC driver, these accounts are also granted the SqlJDBCXAUser role. For more information, see Enabling XA transactions.
  2. Create the following database account:
    Case Analyzer client database user
    Unique identifier
    ca_client_database_user
    Description

    The Windows (local or domain) user that you use to log on to the Case Analyzer Client server. This user must have permission to access the OLAP cubes on the Case Analyzer analysis server. This permission allows the client to connect to the Case Analyzer OLAP database.

    Configuration instructions
    For additional information about how to create this type of user account, see Granting access rights to the Case Analyzer OLAP database. Either of the following configuration scenarios might apply, depending upon the configuration of the environment:
    • If the analysis server and Case Analyzer Client server belong to the same LDAP domain: Give the domain user or group access to the OLAP cubes on the analysis server.
    • If the analysis server and Case Analyzer Client server do not belong to the same domain: Create a duplicate of the client user on the analysis server, and give the user access to the OLAP cubes. When you create the duplicate user, the user must have the same user name and password that is used for the Windows logon to the Case Analyzer Client server.
  3. Record these values in your customized Installation and Upgrade Worksheet. To find this property, search the worksheet for instances of ca_db_administrator and ca_client_database_user.


Last updated: March 2016
bpmpa041.htm

© Copyright IBM Corporation 2016.