Subject: | Processes menu in web framework displays an error when SQL user does not have access to MSDB objects |
Summary: | Processes menu in web framework gives error when SQL user does not have access to MSDB objects |
Audit Notes: | |
11 Jul 2018 | 04:53PM Comment 1 by Alvis (Link Technologies) Case 9426 added to project 09.4 |
12 Jul 2018 | 11:23AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 12-07-2018 11:23 AM Time Taken: 1.00 |
| Development work for this case has been completed. The change will be available in version: 9.4.8.9 1. The following changes were made(Include Database object names, Program classes and any other relevant information):| - When the SQL User does not have access to read objects from MSDB database, we display a message "user does not have access"
2. The issue was caused by: - User permissions were not checked before accessing the object.
3. Next Step - UAT
|
|
12 Jul 2018 | 03:14PM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 12-07-2018 03:14 PM |
| Proceed with UAT |
|
13 Jul 2018 | 12:44PM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 16-07-2018 12:00 AM Time Taken: 1.00 |
| Hi Sanjay, This case has been successfully tested. Documentation is not required in the case. Test Plan - Created a database - LINKSOFTBETA10
- Restored the database - LINKSOFT9426.
- Disabled the "sysadmin" role from Server Roles for linkadmin.
- Log into ESS - Verify the process list. Job Status was - User does not have access.
- Enable the "db owner" role for "Linkadmin" for the LINKSOFT database and the msdb database. Login into ESS, Job Status was updated to "Job is not created".
- Execute process ESS002. The job should run without errors.
Test Environment - Version 948 Beta 11
- LINKOSFTBETA10 on QA1 - Demo Setup
Thanks Rashna/Sanjay |
|
13 Jul 2018 | 02:17PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 13-07-2018 02:17 PM |
| Thanks Rashna |
|
09 Oct 2019 | 08:14AM Comment 6 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019 |