Minimum required privileges for DB2 backend database

To extract data from PeopleSoft using the System Configuration Insight, you require a user who will be assigned Connect and Select privileges on the DB2 backend database.

To create an approva_hr user who will have these privileges, proceed as:

  1. Log into the server where DB2 has been setup with a Windows login having Administrator rights.
  2. From the Computer Management screen (My Computer > Manage > Local Users & Groups) check whether approva_hr user already exists.
  3. If the user does not exist, then create a user having the following details:
    User Name
    Specify approva_hr.
    Password
    Specify approva.
  4. Make the user a member of the windows group DB2USERS.
  5. Place the scripts PSFTHRMSSYSCI.cmd and PSFTHRMSSYSCI_DB2.cmd in a same folder on the machine where DB2 is installed.
  6. From the command prompt, execute the command DB2CMD to go to the DB2 command line processor. This will open up a new command prompt window.
  7. From the new command prompt window, execute the PSFTFISCMSYSCI.cmd script with the following parameters:
    Database Name
    Specify the DB2 backend database name.
    User Name
    Specify the user name for the DB2 backend database.
    Password
    Specify the password for the DB2 backend database.
    Min User Name
    Specify the user name for assigning the minimum privilege.

    This script grants the user the right to connect to the database and also grants access to list of tables.

    For example, PermissionPSFTHRMSSYSCI “FINDMO” “db2admin” “db2admin” “approva_hr”.