Task #1246
Admin Maintenance - ID Creation
| Status: | Work Completed-End life cycle | Start date: | December 05, 2011 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | December 09, 2011 | |
| Assignee: |  Norhaidah Md Dasuki | % Done: | 100% | |
| Category: | Admin Maintenance | Spent time: | 19.00 hours | |
| Target version: | - |
Description
Related to SIT:Redmine - http://10.6.6.20:8080/redmine/issues/6
To re-use the <Username> which has been deleted. Currently, Agrobank practice using Employee ID as <Username>. The Employee ID can be assigned to the New/Re-employ Employee.
History
#1
Updated by Tan Lee Yong almost 13 years ago
- Due date set to December 09, 2011
- Assignee changed from Tan Lee Yong to Ahmadi Hadi
- Start date changed from October 28, 2011 to December 05, 2011
Hi Hadi,
Please assist to look into this. In order to cater for this in our current design, we are thinking to archive the deleted id to another table. This can solve the current problem of reuse of username.
#2
Updated by Tan Lee Yong almost 13 years ago
- Assignee changed from Ahmadi Hadi to Rayvandy Gabbytian
#3
Updated by Rayvandy Gabbytian almost 13 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
- % Done changed from 0 to 40
to enable such approach, currently I'm doing the amendment on the AdminSharedService, to do
1. soft delete the admin user which is already done
2. backup the IB_USER, TB_AM_USER, TB_AM_USERMAS, etc to ADMIN_USER_DELETED_ARCHIVE
3. hard delete the admin user from those table
#4
Updated by Siti Norahayu Mohd Desa over 12 years ago
Hi Gabby,
Kindly update the issue pls.
#5
Updated by Siti Norahayu Mohd Desa over 12 years ago
Siti Norahayu Mohd Desa wrote:
Hi Gabby,
Kindly update the progress issue pls.
TQ
#6
Updated by Rayvandy Gabbytian over 12 years ago
- % Done changed from 40 to 70
- Estimated time set to 6.00
Backup for these table had been successfully implemented:
1. TbAmTac
2. backupTbAmUser
3. backupTbAmUsermas
4. backupAdminUserProfile
5. backupAdminUserSecurity
Table those are successfully be deleted:
1. TbAmTac
2. backupTbAmUser
3. backupTbAmUsermas
Not Successful yet:
4. backupAdminUserProfile (foreign key constraint problem)
5. backupAdminUserSecurity (pending after no.4)
when these 2 tables can be solved, the user deletion will be done
#7
Updated by Rayvandy Gabbytian over 12 years ago
- % Done changed from 70 to 100
- Estimated time changed from 6.00 to 7.00
Done
#8
Updated by Rayvandy Gabbytian over 12 years ago
- Status changed from Development / Work In Progress to Internal Testing
- Assignee changed from Rayvandy Gabbytian to Hafizudin MD
- % Done changed from 100 to 0
- Estimated time deleted (
7.00)
Bang Hafiz, please do a thorough test in SIT/UAT
go to IBAM -> User Profile Maintenance
1. Create new user "test123"
2. Delete this user "test123"
3. Create again new user "test123"
4. check the database of:
- ADMIN_USER_PROFILE_BACKUP
- ADMIN_USER_SECURITY_BACKUP
- TB_AM_TAC_BACKUP
- TB_AM_USER_BACKUP
- TB_AM_USERMAS_BACKUP
Expected:
1. Those tables must have the same field as before the admin user is deleted.
2. "username already exist" should not be appeared
3. new re-created user should be able to login
#9
Updated by Hafizudin MD over 12 years ago
- Assignee changed from Hafizudin MD to Norhaidah Md Dasuki
- % Done changed from 0 to 100
tested by hafiz
status : passed
#10
Updated by Norhaidah Md Dasuki over 12 years ago
- Status changed from Internal Testing to Pending Customer Feedback
#11
Updated by Norhaidah Md Dasuki over 12 years ago
- Status changed from Pending Customer Feedback to Work Completed-End life cycle
Backup for these table had been successfully implemented:
1. TbAmTac
2. backupTbAmUser
3. backupTbAmUsermas
4. backupAdminUserProfile
5. backupAdminUserSecurity
User deletion will be done and New ID using same Username can be created.
6/3/2012 - Tested and confirm by User