Changing a user id in T_METUSER

You can use this procedure to help you find all columns with a certain name:

CREATE proc [dbo].[LP_FINDCOL]

@colname varchar(30) = '%'

as

select 'Search value = '+ @colname

print ' '

select

'source_table'=convert(char(30),object_name(s.id)),

'column_name'=convert(char(30),s.name),

'datatype'=convert(char(12),t.name),

s.length

from syscolumns s

left join systypes t on s.usertype = t.usertype

join sysobjects o on s.id = o.id

where

--o.type = 'U'

s.name like '%' + @colname +'%'

order by convert(char(30),object_name(s.id))

Why not however just change the user’s lname in t_metuser in the security module?  Then you can query the right name in your reports.

BWG

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gawain Lavers
Sent: Friday, September 13, 2013 2:28 PM
To: Brian W. Grundstrom
Subject: Re: [Tessitura Technical Forum] Changing a user id in T_METUSER

Crickets?  Has no one ever had to change a user id in T_METUSER to accommodate a name change?

Am I right to suppose that starting to move solicitors/workers out of T_METUSER is a step on the way to keying users on an integer id so that the text ids will be editable?

In the meantime I have a user who has changed their name through marriage and would like that reflected in their user id.

My thought would be to create a brand new user, then go through and update all solicitation references to the old user to point to the new user.  I'd lose a direct connection to things like the audit trail, but I don't think there would be any other issues, right?  I'm assuming I can do direct updates on the solicitation tables...

table_nameref_count

T_CONTRIBUTION 1974

T_ORDER771

T_SOLICITATION947

T_SPECIAL_ACTIVITY8454

TX_SOL_TASK  123

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!

You can use this procedure to help you find all columns with a certain name:

CREATE proc [dbo].[LP_FINDCOL]

@colname varchar(30) = '%'

as

select 'Search value = '+ @colname

print ' '

select

'source_table'=convert(char(30),object_name(s.id)),

'column_name'=convert(char(30),s.name),

'datatype'=convert(char(12),t.name),

s.length

from syscolumns s

left join systypes t on s.usertype = t.usertype

join sysobjects o on s.id = o.id

where

--o.type = 'U'

s.name like '%' + @colname +'%'

order by convert(char(30),object_name(s.id))

Why not however just change the user’s lname in t_metuser in the security module?  Then you can query the right name in your reports.

BWG

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gawain Lavers
Sent: Friday, September 13, 2013 2:28 PM
To: Brian W. Grundstrom
Subject: Re: [Tessitura Technical Forum] Changing a user id in T_METUSER

Crickets?  Has no one ever had to change a user id in T_METUSER to accommodate a name change?

Am I right to suppose that starting to move solicitors/workers out of T_METUSER is a step on the way to keying users on an integer id so that the text ids will be editable?

In the meantime I have a user who has changed their name through marriage and would like that reflected in their user id.

My thought would be to create a brand new user, then go through and update all solicitation references to the old user to point to the new user.  I'd lose a direct connection to things like the audit trail, but I don't think there would be any other issues, right?  I'm assuming I can do direct updates on the solicitation tables...

table_nameref_count

T_CONTRIBUTION 1974

T_ORDER771

T_SOLICITATION947

T_SPECIAL_ACTIVITY8454

TX_SOL_TASK  123

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!