Feature - Alternate Security for Viewing Database Activity

Feature - Alternate Security for Viewing Database Activity

Release Date: 7/9/2021
Versions: 8.5 and Higher

Background

It could be helpful in certain circumstances to view the last several database I/O operations.  While some users are allowed to do this whenever necessary, this generally is not allowed for security reasons. 

This new feature allows for an administrator to temporarily give permission for a non-privileged user to employ this feature during the life of an Elliott task.

Using the Feature
Let's say, for example, a process seems to be in a loop that does not end. The user may press Ctrl+Shft+D to try to view the most recent database activity. If they do not have that permission, they will be prompted for the SUPERVISOR password to get temporary permission:


If the user (or more likely an administrator) enters the correct password, the database activity log will appear and the user will continue to have the ability to view it without additional SUPERVISOR password prompts for the duration of the task.

If, however, you enter an incorrect password three times, you no longer will be prompted for a password nor have the ability to view the database activity for the duration of the task.

See the following KB article for related information:

JEG



    • Related Articles

    • Feature - View Database Activities Through Control-Shift-D Key

      Version 8.5 & Up Release Date: 7/7/2021 Control-Shift-D Support in the Past The Control-Shift-D key has been available in Elliott since V7.x. It is a very useful tool for debugging purposes. For example, let's say you started to notice performance ...
    • How to Create CPHSTTRX_VIEW with Left Join to CPINVHDR Due to Invoice Database Archive

      Release Date: 12/6/2019 Version: All Q - I had to run Archive Invoices in the old fashioned way as the company ran out of invoice numbers and I didn’t have time to go to 8.5 (modifications). I ran the Archive procedure as outlined in the KB article ...
    • Feature - Added the Ability to Purge the System Activity Log

      Release date: 8/27/2018 This feature will give the user the ability to selectively purge the data from the System Activity log file (SYLOGFIL). This file stores the following information: Elliott user login Web Services login (from your website) ...
    • Feature - Performance Options for eContact Activity Tab

      Release date: 1/13/2017 (V8.1 and V8.2) Sometimes there are so many activity records associated with a contact or company that it takes several seconds to load them all into the lists on the Activity tab of the eContact Information screen. This new ...
    • Salesman Security

      Released Date: 08/30/2017 Sometimes your organization may use outside sales representatives. These reps, often, are not your real employees. In many cases, they represent multiple vendors' products. If you choose to let them access your Elliott ...