Kbase P20980: No one can remember the sysop password for RoundTable
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/13/2003 |
|
Status: Unverified
GOAL:
What to do if no one can remember the sysop password in RoundTable?
FIX:
1. Start up a PROGRESS client
2. Connect to the RTB repository db
3. Dump the PROGRESS _user records to a ".d" file
4. Delete the PROGRESS _user records using the code below.
5. Restart RTB and login and redefine the sysop user
6. Edit the ".d" file to remove the old sysop _user record
7. Use the PROGRESS client to reload the _user ".d" file back into RTB
/** IMPORTANT: BEFORE RUNNING THIS CODE, VERIFY THAT the _user SCHEMA TABLE WAS SUCCESSFULLY DUMPED TO A ".d" FILE. THIS CODE WILL DELETE ALL _user RECORDS **/
for each _user exclusive-lock:
delete _user.
end.