• Replies 7 replies
  • Subscribers 338 subscribers
  • Views 92 views
  • Users 0 members are here
Related

Change User ID

Kris Shaw
$organization

I have a user who would like to have their User ID changed to reflect a change in their last name.

Is User ID a unique/primary key and/or will changing it having any long term consequences? Or is it merely a user attribute?

Thanks!

-Kris

Parents
  • Former Member
    Former Member $organization
    User id is used in all sorts of places to tag who did what, but also in some places to mark ownership. Changing it is not a good idea, because that would break all those links to the history.
    Best thing to do is to create a new id and inactivate the old one, then update the tables where it's used to flag ownership. Lists and report schedules are the ones that leap to mind, but there may be others. If you use solicitations you might want to update those, for example, to keep the user's activities together for reporting.

    Ken McSwain
    +61 (0)418 659 360
    Sent from BlackBerry
    Please consider the environment before printing this email.
    =====This message is intended for the addressee(s) named and may contain confidential information.
    If you are not the intended recipient, please delete it and notify the sender.
    Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====
Reply
  • Former Member
    Former Member $organization
    User id is used in all sorts of places to tag who did what, but also in some places to mark ownership. Changing it is not a good idea, because that would break all those links to the history.
    Best thing to do is to create a new id and inactivate the old one, then update the tables where it's used to flag ownership. Lists and report schedules are the ones that leap to mind, but there may be others. If you use solicitations you might want to update those, for example, to keep the user's activities together for reporting.

    Ken McSwain
    +61 (0)418 659 360
    Sent from BlackBerry
    Please consider the environment before printing this email.
    =====This message is intended for the addressee(s) named and may contain confidential information.
    If you are not the intended recipient, please delete it and notify the sender.
    Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====
Children
No Data