Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Stat Upgrade Script UORAv600-630.sql has a mistake
Description
Unable to open User Rights in the Access information window in Stat 6.3
Cause
Looking at the User Class rights, for STAT-4222 the "CSR Open By - Change" user right should be changed to 'CSR Created By - Change'.
The SQL update that should make this change is wrong in the condition RIGHT_CD.
UPDATE STAT.SYSTEM_RIGHTS SET DESCR = 'CSR Created By - Change', DESCR_LONG = 'Enables the user to override the default Created By User Name on a CSR.' WHERE RIGHT_CD = 'CSREDIT' <--- This column is wrong AND RIGHT_CD = 'OPENBY-C';
The column RIGHT_CD is named twice with two different values.
Resolution
Solution:
- Modify the update statement as below:
UPDATE STAT.SYSTEM_RIGHTS SET DESCR = 'CSR Created By - Change', DESCR_LONG = 'Enables the user to override the default Created By User Name on a CSR.'
WHERE RIGHTS_GRP = 'CSREDIT' AND RIGHT_CD = 'OPENBY-C';
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Recommended Content
Product(s):
Stat
6.3
Topic(s):
Installation
Article History:
Created on: 9/9/2021 Last Update on: 5/7/2023
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
Search All Articles
IE 8, 9, & 10 No longer supported
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.
