nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

What is best way to update usernames in JIRA (LDAP) without DB changes ?

Deepti Rao

Hi,

We have a JIRA instance that currently has usernames in below format:

firstname.lastname

We wish to update all usernames in JIRA with users email id instead.

Changing username through JIRA UI does not update all associated mapping.

Can someone tell me the best workaround with data integrity?

Accepted answers

All comments

Vickey Palzor Lepcha

Are you sure about this ? This is going to be very confusing - what about all the old issues that have already been created and closed. They are all tagged to current username format - you will have to even replace them and that would be pretty risky,

Bastian Stehmann

Hi,

can you clarify, what mappings are not updated? We rename users often via UI or REST-API and never had problems with this.

Maybe this explanation helps to make it a bit more clear how Jira works.

Jira has to different attributes for users, the username and the userkey.

The username is used for login or if you type in a username manually in a field, whereas the userkey is the unique ID of the user, that is linked to the username and the userkey is the value that is saved to the database.

When you create a new user, both are usally the same.

When you change the username in the UI, only the username will be changed, so that you can use that for login or when typing it in manually. The userkey will still remain the inital value, in your case firstname.lastname.

Deepti Rao_y00ohy

When I update username value in JIRA UI, even jiraissue table is not reflecting new username values (Re-indexing too didn't help)

Here are a few more tables that do not get updated if the username changes through JIRA UI :

userassociation (Watches and votes are recorded in the USERASSOCIATION table)

jiraaction (user comments on issues)

userhistoryitem (every users audit log entries)

Change History Database Tables:

changegroup (Each change to the issue triggered by a user inserts one record into the changegroup table)

changeitem (Each changegroup record refers to one or many changeitem records)

(as per an earlier query there are around 18 tables): https://community.atlassian.com/t5/Jira-questions/Change-Username/qaq-p/396703

Can someone tell me if they have come across similar issues and how they resolved the same...

Bastian Stehmann

You are right, that tables are not updated because they must not be updated. What you see, is the userkey, and that stays the same even if you change the username.

That's the trick with keys in databases...

If you want to change the userkey (the id that is referenced everywhere), I see two ways to do that, but both are ways I would not like to go.

First is, to update the keys right in the database in each and every table.
Second is, to do an xml-export and do the same there by find & replace.

Can you tell me, what's the reason why you want to change the key?

Deepti Rao_y00ohy

Hello,

We are merging 2 JIRA instances.. Destination JIRA (one where we are migrating projects) is integrated with AD. So username convention is email id. Source JIRA has convention firstname.lastname (Internal JIRA users). We wish to have all users authenticated through AD.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server