You’re offline. This is a read only version of the page.
70
We have only been using SL for about one year. One of our users got married, and of course we want to change the name in SL to reflect the new name.
We have not been able to figure out how to get it working. Would have liked to just update the username in place. That did not seem to be possible. So we have now "deleted" the old account, and tried to add the new name (as associated with the active directory entry). Keep getting access denied.
Anyone already done something like this (seems like a common request - update username (windows ID) to reflect a name change)?
Example. login was nancysmith, now it will be nancyjones
Thanks
Lou
*This post is locked for comments
Ahh... I was thinking employee as in data within the system such as payroll etc. So since they probably are an employee the app database may still need to be changed but for username purposes probably the Sys like Toni said, although I've never changed that. If you used windows authentication you could just change it in active directory and SL would follow suit.
I think you would need to do that on the SYSTEM database not the app one!
I've been through this scenerio and NexVue (www.nexvue.com) has a product called keychange that allows you to change employee IDs and more its pretty expensive though. A couple years back before we purchased keychange I had this same problem and needed to change everyone's ID because we went from a name (jarvisj) approach to a number. So here's how I tackled the problem:
First I wanted to find all the SQL tables that had the field empid in it so I ran this query:
declare @ColumnName as varchar(50)
SET @ColumnName = 'empid'
SELECT c.name as ColumnName, o.name as TableName FROM syscolumns as c
JOIN sysobjects as o on c.id = o.id
WHERE c.name like @ColumnName and o.xtype='u'
This gave me a list of tables that contained EmpID. So Next I created a series of queries to update the employee IDs from the old way (names) to the new way (numbers). Here is the queries I used for one person. And with the help of excel i was able to mass produce queries to do the entire company.
update APTranDt SET empid='0000' WHERE empid='SMITH'
update CalcChk SET empid='0000' WHERE empid='SMITH'
update CalcChkDet SET empid='0000' WHERE empid='SMITH'
update smWrkSvDetail SET empid='0000' WHERE empid='SMITH'
update smEmpPhone SET empid='0000' WHERE empid='SMITH'
update smEmpSchedule SET empid='0000' WHERE empid='SMITH'
update smInvDetail SET empid='0000' WHERE empid='SMITH'
update POAlloc SET empid='0000' WHERE empid='SMITH'
update BenEmp SET empid='0000' WHERE empid='SMITH'
update EarnDed SET empid='0000' WHERE empid='SMITH'
update Employee SET empid='0000' WHERE empid='SMITH'
update PRCheckTran SET empid='0000' WHERE empid='SMITH'
update PRDoc SET empid='0000' WHERE empid='SMITH'
update smServDetail SET empid='0000' WHERE empid='SMITH'
update smServFault SET empid='0000' WHERE empid='SMITH'
update PRTran SET empid='0000' WHERE empid='SMITH'
update StubDetail SET empid='0000' WHERE empid='SMITH'
update W2Federal SET empid='0000' WHERE empid='SMITH'
update W2StateLocal SET empid='0000' WHERE empid='SMITH'
update smSplCommDetail SET empid='0000' WHERE empid='SMITH'
update WrkW2Form SET empid='0000' WHERE empid='SMITH'
update smservhist SET empid='0000' WHERE empid='SMITH'
update smVehOdom SET empid='0000' WHERE empid='SMITH'
update W2EmpName SET empid='0000' WHERE empid='SMITH'
update smWrkDetailInv SET empid='0000' WHERE empid='SMITH'
update smWrkEmp SET empid='0000' WHERE empid='SMITH'
Now as a disclaimer, I did this probably on Solomon version 5. Plus we didn't have the entire solution implemented, so you could have different tables than we did. Plus now there are different things such as Windows Authentication and things where I'm not sure how this would act. If you do anything be sure to do it on a test database! This is just to tell you how I did worked around this problem.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,782
Super User 2024 Season 2
#2
Martin Dráb
229,067
Most Valuable Professional
#3
nmaenpaa
101,150
Share
Report
All responses (
Answers (