Unable to log in as Partition Administrator (pa) or System Administrator (sa)
From DocWiki
Contents |
Scenario Setup
Log all administrators out
Database Server
- Set PA and SA passwords to some random encrypted text
Problem Statement
Unable to log in to the default partition as pa. The login will fail:
The same is true for the system partition. Remember that the sa user is a system user and can only log in to partitionId=0. The login will fail the same as for pa.
| Administrator user | eG Database |
|---|---|
| PA | eGActiveDB |
| SA | eGMasterDB |
No more administration?
SA and PA are just standalone users defined in eGMasterDB and eGActiveDB, respectively.
The passwords are encrypted once set. If a customer forgets their password, it can be blanked out and reset from within the UI.
Reset SA password:
Run the following against the eGMasterDB:
select * from egpl_user
Verify that the SA user's ID is 1. Then run the following query, also against the eGMasterDB:
UPDATE egpl_user WITH (ROWLOCK) SET password = '', case_insensitive_password = '' WHERE user_id = 1;
Reset PA password:
Run the following against the eGActiveDB:
select * from egpl_user
Verify that the PA user's ID is 1. Then run the following query, also against the eGActiveDB:
UPDATE egpl_user WITH (ROWLOCK) SET password = '', case_insensitive_password = '' WHERE user_id = 1;
Reset Passwords from UI
Log in as SA and PA with blank passwords. Navigate to the Administration console > Users and change the password.
Resolution
Resetting forgotten PA and SA user (and other standalone user) passwords is simple with a few quick SQL queries and updates.
