Minimum required privileges for DB2 backend database

To extract data from the FISCM, a user requires ‘Connect’ and ‘Select’ privileges on the DB2 backend database.

To create an ‘approva_fi’ user who will have these privileges:

  1. Log into a server where DB2 has been setup with a Windows login having Administrator rights.
  2. From the Computer Management screen (MyComputer Manage ->Local Users & Groups) check whether ‘approva_fi’ user already exists.
  3. If the user does not exist, then create a user having these details:
    • User Name = approva_fi
    • Password = approva
  4. Clear the User must change password at next logon check box.
  5. Select the Password never expires check box.
  6. Make the user a member of the Windows group ‘DB2USERS’.
  7. Execute the GrantDB.sql script, from the DB2 Command Editor. This script grants the user the right to connect to the database. Update the password of the DB2ADMIN user, if the password is different from that given in the script.
  8. Execute the TableAccess.sql script to grant access to the list of tables. Change the login name and the DB2ADMIN password in the script, if they are different from that given in the script.
  9. Execute CreateAlias.sql. This script creates Alias’ for the tables to be extracted. Change the login name (APPROVA_FI) and the schema name (DB2ADMIN) if they are different from the values given in the script.
    Note: Minimum permission scripts are shipped and can be obtained from the IRC Adapters CD under PeopleSoft\MinimumPermissions folder.