Wiki

Options

New Case Case Status
Log In

Wiki

Options

 
Knowledge Base Articles»KB100018 - Restoring EtaPRO Ac…
  • RSS Feed

Last modified on 12/5/2018 5:07 PM by User.

KB100018 - Restoring EtaPRO Access Following Accidental Authentication Change

Problem

It is possible to accidentally restrict all access to the EtaPRO system including the ability to add/modify user accounts. This situation typically arises when the EtaPRO Security mode (EtaPRO or Windows) is switched between modes without first ensuring that an account with Security and Unit Administrator rights exists in both modes.

Figure 1 - EtaPRO Security Mode: EtaPRO

Figure 2 - EtaPRO Security Mode: Windows

If your EtaPRO authentication mode has been changed to Windows mode, and there are no Windows accounts assigned to Security, EPReporter or Unit roles:

1. You may be prompted to enter a Username/Password/Domain

Figure 3 - Login Prompt (Windows Authentication)

2. Upon entering a correct Windows Username/Password/Domain, the following appears:

Figure 4 - Invalid Username or Password message

If your Windows authentication mode has been changed to EtaPRO mode, and there are no EtaPRO accounts assigned to Security, EPReporter, or Unit roles:

1. You will be prompted to enter a Username/Password

Figure 5 - Login Prompt (EtaPRO Authentication)

2. Upon entering a correct EtaPRO Username/Password, the following appears:

Figure 6 - Permission Denied message

Solution

Preventing Loss of Access

To avoid locking users out of EtaPRO, make sure that there is always at least one account with Security and Unit Administrator rights set up in BOTH the EtaPRO and Windows Security modes. In the event that a user is accidentally “locked out” of the EtaPRO system, this account can then be used to log in and switch back to the original security mode, or make any necessary changes to user account settings.

For additional assistance with this procedure or to report an error, please contact EtaPRO Support at etaprosupport@gpstrategies.com or 716-799-1077.
  1. Select the Configuration | Enter Edit Mode command and then click the System Configuration button on the EtaPRO toolbar to display the Configuration Tools screen.
  2. Click the User Management button to display the User Management dialog.
  3. If the EtaPRO Security Mode button is enabled:
    1. Check to see that your administrator username is displayed under both the Security and Unit Administrator nodes.
    2. If not, right-click on the Administrator nodes and click on the Assign User to Role command.

Figure 7 - Assign User To Role

  1. The Select User dialog displays. Highlight your administrator name and click OK. Repeat this process for any Administrator nodes where your username is missing.

Figure 8 - Select User

  1. Switch to the Windows mode and check to see if your username is displayed under both the Security and Unit Administrator nodes.
  2. If not, right-click on the Administrator nodes and click on the Assign User/Group to Role command.

Figure 9 - Assign User/Group To Role

  1. The Enter Username/Group dialog displays. Highlight your administrator name and click OK. Repeat this process for any Administrator nodes where your username is missing.

Figure 10 - Enter Username/Group

IMPORTANT! Switch back to the EtaPRO Security mode BEFORE clicking OK to close the User Management dialog.
  1. If the Windows Security Mode button is enabled:
    1. Check to see that your administrator username is displayed under both the Security and Unit Administrator nodes.
    2. If not, right-click on the Administrator node and click on the Assign User/Group to Role command.
    3. The Enter Username Group dialog displays. Highlight your administrator name and click OK. Repeat this process for any Administrator nodes where your username is missing.
    4. Switch to the EtaPRO mode and check to see if your username is displayed under both the Security and Unit Administrator nodes.
    5. If not, right-click on the Administrator node and click on the Assign User to Role command.
    6. The Select User dialog displays. Highlight your administrator name and click OK. Repeat this process for any Administrator nodes where your username is missing.
IMPORTANT!  Switch back to the Windows Security mode BEFORE clicking OK to close the User Management dialog.

Restoring Access Using SQL Queries

If all users have been “locked out” of EtaPRO, access can be restored by modifying the EtaPRO plant database directly.

IMPORTANT!  Modifying EtaPRO databases using SQL queries is NOT RECOMMENDED and has the potential to cause irreparable damage to the EtaPRO system. GP Strategies is not responsible for any damage that may be caused by incorrect and/or accidental changes made to the EtaPRO databases including but not limited to database corruption and data and/or table deletion. If you are unfamiliar with SQL databases and queries, DO NOT attempt this procedure. Please contact EtaPRO Support at etaprosupport@gpstrategies.com or 716-799-1077 for assistance.