# Is it possible to change users SSO's external\_id after a DB migration?

**URL:** <https://meta.discourse.org/t/is-it-possible-to-change-users-ssos-external-id-after-a-db-migration/62099>\
**Category:** Product Support\
**Created:** [May 4, 2017, 10:57am UTC](https://meta.discourse.org/t/is-it-possible-to-change-users-ssos-external-id-after-a-db-migration/62099 "2017-05-04T10:57:02Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![caub](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/caub/32/121044_2.png) [@caub](https://meta.discourse.org/u/caub)\
**Post date:** [May 4, 2017, 10:57am UTC](https://meta.discourse.org/t/is-it-possible-to-change-users-ssos-external-id-after-a-db-migration/62099/1 "2017-05-04T10:57:02Z")

</div>

First I had issues with the external\_id field on SSO, because they were all initially strings of length 16, and later I stored 24chars strings, but it completely messed up, you could get logged under a different user, it seems it cropped the external\_id length, but that was hard to debug.

So I make sure to keep external\_id with the same length, it’s not really practical, why not using a TEXT column type for it?

And my question is also, can I update the external\_id of existing users, after doing a DB migration on my external site that provides SSO? and allow those users to keep their existing discourse profile when they’ll log in

Thanks for that good work

---

_[View the full topic](https://meta.discourse.org/t/is-it-possible-to-change-users-ssos-external-id-after-a-db-migration/62099)._
