To create an APPROVA_CDM user with the required privileges, proceed as follows:
Log into a SQL server with a Windows log in with Administrator rights.
Check if the APPROVA_CDM user who will be used for extracting data already exists in the SQL Server database by running the following query:
Select * from dbo.sysusers where name ='APPROVA_CDM
Create the APPROVA_CDM user by executing the following code in SQL server management studio by replacing Login Name, Login Password and Database Name (if the APPROVA_CDM user is already present, skip this step and move to step 4):
code for creating Approva CDM user
Run the commands in the CDM_PSFT_MSSQL_PERM.sql file to grant select permission on the required database tables. Change the user name if it is different from the values given in the script.