SQL backend

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

  1. Log into a SQL server with a Windows log in with Administrator rights.
  2. 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
  3. 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
  4. 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.