How to change username in Jira ?


My first question has been solved but adding the Internal with LDAP Authentication User Directory could dupplicate some real users with two usernames.

Indeed, our first application was open to external users but managed by some internal users and their accounts have been created sometime with a different username than the uid they have in our LDAP.

Now, I wish to change username and directory of these internal users to the right LDAP uid and affect them in the Internal with LDAP Authentication User Directory.

I've explored the database and unfortunately there are many tables that use username instead of using foreign key referencing cwd_user.ID.

Is there a possibility to change username via Jira interface or do I have to develop a script to change usernames in all the database tables they figure ?

3 answers

1 accepted

3 votes
Accepted answer

Jamie Echlin's excellent scriptrunner plugin ( includes a script to rename users.

Thank you John for your indication. This plugin is already installed on my Jira server and it works well !

Now, I need to change the directory of the users that I've changed their username to move them in the "Internal with LDAP Authentication User Directory".

Lokking in the database shows it's the same problem : directory_id is indicated in more than one table.

I can't see a similar function in the plugin or elsewhere in Jira admin interface. Does it exists ?

Hi Philippe,

The only way to change usernames in JIRA is to export the data to XML format, open it in an editor and then use Find & Replace to manually change all the instances of the username in the XML. After that you can then restore the XML data again and the usernames will have been changed. However, this isn't really recommended, (even though it generally works), so please try it first in a test environment before deploying it to production.

All the best,

You could also create a new username and bulk change all issues assigned/reported by the old user to the new one, as explained in Changing usernames in JIRA.

The link is dead.

And unfortunately it's not done with bulk changing the issues. There are filter, dashboards, history, ...

David Simpson Community Champion Jun 26, 2013

@Nabil Sayegh try:

Or upgrade to JIRA 6 - JRA-1549 has been resolved ;)

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,172 views 5 10
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you