Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Cannot rename employee in CA

Created: 17 Apr 2006 • Updated: 21 May 2010 | 6 comments

Hi all,
I got a weird issue: I don't see the way to rename employee in CA...
One of CA users got married, so account got changed in AD... When I go to CA/Application Administration/Employees, it listed the mentioned employee with exclamation mark... When I click the employee is see an error:
Error: Could not find 'Domain\Oldusername', the user may have been deleted. (Name translation: Could not find the name or insufficient right to see name.)

This is kind of make sense, because the username was renamed to Newusername, but when I click 'Browse' I can't navigate to the user (it does not exist in the list probably because the user was already added), so I can't fix naming... Delete is also not available anywhere...

So I'm kind of stuck...

Do you know a way to rename an employee in CA?

Thanks in advance!

-Victor

Discussion Filed Under:

Comments 6 CommentsJump to latest comment

TonySterling's picture

Victor,
What version of CA are you running? I know if CA 6 there is a table called tblPrincipal with a column PrincipalLogin. I am do not remember what correlating entries are in 5 or 5.1, but it should be very similar.

Any how, you can manually change the login in the SQL table. I normally do not recommend changing the DB directly, but in this case I don't recall any other way around it. I would be safe and make a back up the CA database and then use SQL Enterprise Manager to find the user and change it in the table. :)

Victor Geyyer's picture

> Victor,
> What version of CA are you running? I know if CA 6
> there is a table called tblPrincipal with a column
> PrincipalLogin. I am do not remember what
> correlating entries are in 5 or 5.1, but it should be
> very similar.

Thank you very much... I'm running version 5... There is no tblPrincipal table, but there is a tblAddressUser table, which looks very similar, but I don't know if this table has relationship to other tables, because the mentioned user should not loose rights to CA...

TonySterling's picture

Is there a column that has the domain\user name in it? Like I say, I do not remember 5 that well as it has been a while. You should consider upgrading to at least 5.1 sp4. I think you would get a lot of benefit from it. :)

Victor Geyyer's picture

> Is there a column that has the domain\user name in
> it? Like I say, I do not remember 5 that well as it
> has been a while. You should consider upgrading to
> at least 5.1 sp4. I think you would get a lot of
> benefit from it. :)

I'm running v5.1 (to be exact 5.13)... I think it's 5.1 sp3... I'm just afraid changing it in one table and not changing in another table, which might have relationship with the original one...

TonySterling's picture

Are you sure there isn't a table called tblPrincipal? I looked into the SQL scripts and there are references to that table.

That would be the only place you would have to change it.

Victor Geyyer's picture

> Are you sure there isn't a table called tblPrincipal?
> I looked into the SQL scripts and there are
> references to that table.
>
> That would be the only place you would have to change
> it.

Yes... It was my fault... There is the tblPrincipal table... I have no idea why I did not see it the first time (I'm getting old probably :))
Thanks for your help!
-Victor