Modern Survey Connection - Take Survey URL

when an incident is closed, a 'take survey' end point url is generated, directing end users to submit their survey responses previously, this url lacked authentication as part of our security enhancements, we've introduced sql user authentication for accessing the 'take survey' endpoint the endpoint now requires the creation and linkage of a specific sql user to tenants to function correctly ensure that the required sql user is set up and associated with the relevant tenants for continued access to the 'take survey' url take survey end point https //{tenant url}/heatsurvey/takesurvey?action=take survey configuring an sql user for each tenant database create a separate sql user for each tenant database in your landscape, create a dedicated sql user with limited permissions using below sql query ensure to replace \<username>, \<password>, and \<db name> with the appropriate values create login \<username> with password = '\<password>', check policy = off, default database = \<db name>; exec \[sys] \[sp adduser] \<username>; grant select on \[dbo] \[frs survey] to \<username>; grant select on \[dbo] \[frs surveyquestion] to \<username>; grant select on \[dbo] \[frs surveyquestioncategory] to \<username>; grant select on \[dbo] \[frs surveychoice] to \<username>; grant select, update, insert on \[dbo] \[frs surveysession] to \<username>; grant select, update, insert on \[dbo] \[frs surveyanswer] to \<username>; configure the sql user in the tenant log in to the config tenant navigate to the tenants workspace select the tenant where the sql user was created navigate to the survey connection child tab enter the sql user’s username and password created in step 1 docid\ rurokg0t6qq1az4zgt7p8 into the survey username and survey password fields save the configuration related topics javascript\ void(0);