06-03-2010 08:00 AM
06-03-2010 08:53 AM
If you don't have remote users or offices, you can run a series of update statements to reset all records & fields with the old UserID to the new UserID. If you do have remote offices or users, you could run the statements inside the Admin SQL tool, or write a VB script in Architect that will be run once from the Admin login. Be sure to test this on a backup database first. You also may want your business partner to help you with this.
06-03-2010 09:27 AM
06-03-2010 10:04 AM
06-03-2010 12:48 PM
Thanks for you help. I got this resolved. It was messy but worked. Did on test environment first (of course).
THIS IS ONLY TO BE PERFORMED BY A DATABASE ADMINISTRATOR!!!
1. Figure out old userid
2. Create new account in SLX admin tool
3. Find new userid in userinfo table
4. Update userid in UserInfo table
5. Update userid in UserSecurity table
6. Update userid in UserProfile table
7. Remove old records from UserOptions table & update new records
8. Remove old records from UserSecFunctions & update new records
9. Update accessid field in SecRights table
06-15-2010 07:47 AM
Glad you were successful on this.
Just a quick FYI: the USERID definitely has something to do with the encrypted password algorithim, which is the reason you couldn't get access for the old converted from new userid and the old password.