edx-documentation icon indicating copy to clipboard operation
edx-documentation copied to clipboard

Changing ID in an user (table auth_user)

Open edxnanfor opened this issue 6 years ago • 2 comments

ID of every user in edX is set automatically (with a new number from last users we have, as a primary key) For example, ID User 1 userA 2 userB 3 userC

But, Microsoft (for example Academy.microsoft.com) use this ID for different activities (for example certificates)

For example, userB has finished lot of courses, but its id (2) is problematic. How can it be changed to a new ID? renaming previous user and creating a new one is not an option, because new user has not all his/her courses.

Is it possible? Changing directly in MySQL will affect information in Mongo, so it doesn't appear to be an option. For example ID User 888 UserB

We are Microsoft's partner, with an edX portal and we've got trouble with this elements. Thanks and regards Julio

edxnanfor avatar Apr 06 '18 12:04 edxnanfor