Difference between revisions of "Change User Name"
Jump to navigation
Jump to search
(New page: Usually this has to do with a user getting married and wanting to change their username Procedure: In SA change the users Name to what you will want it to be In SA change the Mnemonic to...) |
|||
Line 1: | Line 1: | ||
− | |||
Usually this has to do with a user getting married and wanting to change their username | Usually this has to do with a user getting married and wanting to change their username | ||
Procedure: | Procedure: | ||
− | In SA change the users Name to what you will want it to be | + | # In SA change the users Name to what you will want it to be |
− | In SA change the Mnemonic to what you want it to be | + | # In SA change the Mnemonic to what you want it to be |
− | Log into TWAdmin and delete user | + | # Log into TWAdmin and delete user |
− | Create a new user making sure that they are setup as USER and NOT USER/PROVIDER | + | # Create a new user making sure that they are setup as USER and NOT USER/PROVIDER |
− | Notify Technical Support of the the username that you deleted | + | # Notify Technical Support of the the username that you deleted AND the username that you created |
− | + | The technical support rep will need to perform the following: | |
+ | # Pull Old ID with the following: Select * from IDX_User where ausername Like '%OldUserName' | ||
+ | # Pull New ID with the following: Select * from IDX_User where ausername Like 'NewUserName' | ||
− | + | Then Run the following to update the links: | |
− | |||
− | |||
− | |||
− | |||
− | |||
Update IDX_User set IsinactiveFlag = 'Y' where ID = NewID | Update IDX_User set IsinactiveFlag = 'Y' where ID = NewID | ||
Update IDX_User set ausername = 'zzztgodwin' where ID = NewID | Update IDX_User set ausername = 'zzztgodwin' where ID = NewID | ||
Line 27: | Line 23: | ||
zzztogowin is the rename of the 'old' userid | zzztogowin is the rename of the 'old' userid | ||
togodwin is the new username. | togodwin is the new username. | ||
+ | |||
+ | (NOTE the user will have to re-select their site when logging in) | ||
Testing: | Testing: | ||
− | Verify that the user now shows in TWAdmin as User/Provider | + | # Verify that the user now shows in TWAdmin as User/Provider |
− | Verify that you can log in the user and see the schedule, tasks search patients. | + | # Verify that you can log in the user and see the schedule, tasks search patients. |
Revision as of 13:27, 18 July 2008
Usually this has to do with a user getting married and wanting to change their username
Procedure:
- In SA change the users Name to what you will want it to be
- In SA change the Mnemonic to what you want it to be
- Log into TWAdmin and delete user
- Create a new user making sure that they are setup as USER and NOT USER/PROVIDER
- Notify Technical Support of the the username that you deleted AND the username that you created
The technical support rep will need to perform the following:
- Pull Old ID with the following: Select * from IDX_User where ausername Like '%OldUserName'
- Pull New ID with the following: Select * from IDX_User where ausername Like 'NewUserName'
Then Run the following to update the links:
Update IDX_User set IsinactiveFlag = 'Y' where ID = NewID Update IDX_User set ausername = 'zzztgodwin' where ID = NewID Update Person set IsInactiveFlag = 'Y' where ID = NewID Update IDX_User set Ausername = 'tgodwin' where ID = OldID Update IDX_User set IsinactiveFLAG = 'N' where ID = OldID
NOTE: NewID and OldID are numeric "ID" fields that link Person and IDX_User, not the Old/New UserID. zzztogowin is the rename of the 'old' userid togodwin is the new username.
(NOTE the user will have to re-select their site when logging in)
Testing:
- Verify that the user now shows in TWAdmin as User/Provider
- Verify that you can log in the user and see the schedule, tasks search patients.