We often face this in Ballet. I am curious to know how others handle it. When people get married they want us to change their tessitura login name (userid) and when they get separated they want to go back to their original login (part of life). It happened couple of times. For now we are managing it by creating a new login. May be in a future version Tessitura can allow us to change the login name, as long as it is unique, by maintaining a separate primary key to refer & link to different other tables without breaking any referential integrity.
Mo
National Ballet of Canada
Thanks Amanda and Dan for your response, and the awesome script! This will give us some food for thought.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Dan Taraborrelli Sent: Friday, October 28, 2011 2:56 PM To: Mohiuddin Faruqe Subject: Re: [Tessitura Technical Forum] A Practical Issue
We change the name. It involves creating a new user id and then converting all of their historical activity in the database over to that new id. Here is the script developed by our awesome DBA, Katie Lachance-Duffy:
http://dl.dropbox.com/u/414718/Change%20userid%20for%20last%20name%20changes.sql
From: Mohiuddin Faruqe <bounce-mohiuddinfaruqe8297@tessituranetwork.com> Sent: 10/28/2011 12:10:30 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!