All users are locked out of the system - how can this be corrected?

Owned by Beth Blok (Unlicensed)
Last updated: Nov 21, 2022 by Mike SheenVersion comment
1 min read

Problem

No-one, not even the Admin user can log into the database through either a mis-configuration of the menu and/or incorrect permissions applied.

Solution

In the public release after 7.00.175 we have added a Recovery from misconfiguration of menu or permissions.sql script to the Jiwa program\Miscellaneous SQL Scripts\General folder.  This script

  • creates a menu named 'Recovery Menu', with 4 menu items - Staff Maintenance, User Group Maintenance, Menu Maintenance and System Configuration
  • creates a user group named 'Recovery Group' 
  • adds the Admin user to the recovery group, and this group has the Recovery Menu set.

Once run, the Admin user will be able to log in and adjust the menus, groups and staff records to a working state.

Download the attached script for anyone needing it for releases 7.00.175 or prior.

 

Follow these steps to correct the issue.

Advanced SQL skills are required

Advanced SQL skills are required to perform this task successfully

  • Download the attached script and apply it to the relevant database
  • Login to the database as 'Admin'
  • Correct the menus, groups and staff records, including Admin
  • Save all changes
  • Test changes that have been made