Minimum required privileges for DB2 backend database

To extract data, you require a user who will be assigned Connect and Select privileges on the DB2 backend database.

To create an approva_hrms 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_hrms user already exists.
  3. If the user does not exist, then create a user having the following details:
    User Name
    Specify approva_hrms.
    Password
    Specify approva.
  4. Make the user a member of the windows group DB2USERS.
  5. Place the scripts PSFTHRP2PCI.cmd and PSFTHRP2PCI_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 PSFTHRP2PCI.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, PermissionPSFTHRP2PCI “FINDMO” “db2admin” “‘db2admin” “approva_hrms”.