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