To create an APPROVA_CDM user with the required privileges, proceed as follows:
Log into a server where DB2 has been set up with a Windows log in with Administrator rights.
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.
Select the Password never expires check box.
Make the user a member of the Windows group DB2USERS.
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.