Minimum required privileges for DB2 backend database

To extract data from the Authorizations Insight for PeopleSoft HRMS, a user requires Connect and Select privileges on the DB2 backend database.

To create an approva_hr 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 (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.
    User Name
    Specify 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_HR) 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.