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 - http://{tenant url}/HEATSurvey/TakeSurvey?action=take_survey.

Configuring an SQL User for each Tenant Database

1.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.

Copy

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>;

2.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 into the Survey Username and Survey Password fields.

•Save the configuration.