DB2 backend

To create an APPROVA_CDM user with the required privileges, proceed as follows:

  1. Log into a server where DB2 has been set up with a Windows log in with Administrator rights.
  2. From the Computer Management screen (My Computer > Manage > Local Users & Groups) check whether the APPROVA_CDM user already exists. If the user does not exist, then create a user with the following details:
    User Name
    Specify APPROVA_CDM
    Password
    Specify approva

    Clear the User must change password at next logon check box.

  3. Select the Password never expires check box.
  4. Make the user a member of the Windows group DB2USERS.
  5. Run the commands in the CDM_PSFT_DB2_PERM.sql file to create synonyms and grant select permission on the required database tables. Change the Login name (APPROVA_CDM) and the schema name (DB2ADMIN) if they are different from the values given in the script.