User:Ratana Lim
USER ACCOUNT DESIGN PROBLEM
Here is the problem I've been battling over the years with Moodule user account design: The same person have multiple accounts on Moodle user table depending on the authentication method. Here is an example.
| id | firstname | lastname | email | usrname | auth | idnumber || |1000 | Rt | Lm | ratana@ucsb.... | ratana | ldap | 999999999 | |10001 | Rt | Lm | ratana@ic.ucsb... | ratana@ic | externaldb | 999999999 | |10002 | Rt | Lm | ratana@lsit.ucsb...| ratana@lsit | mnet | |
I am the person that have all the different records in the user table.
Problem #1: I have 3 different accounts in my moodle instance Problem #2: How does an instructor knows which one to enroll me in if it is done manually?
The two main problem ought to be enought to refactor user accounts in the database and the authentication method. User same person ought to have one user record but allout for diferent authentication method (perhaps including the username). Also user ought to maintain a primary email or contact methods independent of the database record.