LDN - Luminis Developer Network

I was approached yesterday by a desktop support person to let me know that the President's assistant had a name change. Our luminis logins are first initial last name, so when someone changes their last name due to a marriage or otherwise, their network login changes.

We all know too well that luminis doesn't allow this to happen, however, I was under a bit of pressure to make this happen for at least the groups feature. The user in question was the admin of many important groups on campus with VPs and the like, so we couldn't really delete that account and have it wreak havoc in the groups.

Thankfully, groups are an SCT bolt on to luminis and are wholly contained in oracle. I can alter oracle.

I checked the GT_USER table and found the user_id (long set if digits) for this user's old account, then checked and found the new account's user_id.

I then updated the following tables / actual sql here -

-- update group tables to change user

update gt_member
set user_id = '457321076919670'
where user_id = '361862410528195'

update gt_chat_message
set user_id = '457321076919670'
where user_id = '361862410528195'

update gt_chat_participant
set user_id = '457321076919670'
where user_id = '361862410528195'

update gt_chat_whisper
set user_id = '457321076919670'
where user_id = '361862410528195'

update gt_file
set user_id = '457321076919670'
where user_id = '361862410528195'

update gt_link
set user_id = '457321076919670'
where user_id = '361862410528195'

update gt_news
set user_id = '457321076919670'
where user_id = '361862410528195'

update gt_photo
set user_id = '457321076919670'
where user_id = '361862410528195'

update gt_request
set user_id = '457321076919670'
where user_id = '361862410528195'

When the user logged into groups (about 10 minutes later - with no bounce!) they were the admin for all the groups they had before, and owned all the assets, files, news postings, messages etc they posted in under the old username.

I'm on a quest to now tackle the main portal - starting with the layout_struct table to get the user's tabs and channel layout the way it was.

... I'll report my progress and probably make this a nice series.