Minimum required privileges for DB2 backend database

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

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