Is there a way to edit the name of a login?
A co-worker had a name change and there seems to be no way to edit his login, we just have to create a new tesitura login for his new name?
As a major gift officer he has many tasks attached to his user name, as well as solicitations. Since these key off of name for reporting we would lose all this information.
Thank you!
Marta
Hi Marta
No, there's no in-system way to change a login. It's too deeply linked to other tables, and to both Tess and SQL security.
AFAIK, the simplest solution (and it's not very simple), is to give your user their new login matching their new name, then decide which existing objects have an urgent need to still belong to them, and veeeerrry carefully use SQL to update the relevant tables in the back end. Not for the faint-hearted, needs SQL skills, and needs to be well tested first, but it it's usually possible to identify the relevant field that needs to be updated, thanks to Tess's reasonably logical naming practices.
You would end up with a string of update statements like this (to transfer List ownership, which you would almost certainly want to do):
update [impresario].[dbo].[T_LIST]
set created_by = 'GINGER'
where created_by = 'FRED'
Ken
This thread might be of interest: http://www.tessituranetwork.com/COMMUNITY/forums/p/5849/18662.aspx#18662
Also if the user had schecduled reports instead of re-scheduling them under their new login you can just change their user so that they can view the reports from Maintain Reports/Utility Schedules under their new login.
http://www.tessituranetwork.com/COMMUNITY/forums/t/6023.aspx
Caryl