Purpose

When planing a mass user renaming activity in Jira, you may wonder whether your Portfolio users and plan permissions will be impacted. 

Solution

It is totally safe to rename your Jira users without any impact on Portfolio. We will explain this below: 

Impact of user name change on the database

• Renaming users in Jira or in an external directory makes the change to the cwd_user table.
• However, if you look at the jiraissue table for instance, the username in the reporter and assignee columns does not change.
• This is because the those columns use the user key which is the very first username of the user when they were added to Jira.
• The mapping between the user_name in cwd_user and the user key is stored in the app_user table.

Impact on Portfolio users

• The value stored in the JIRA_USER_ID column of the AO_82B313_PERSON table for Portfolio is the same as user_key column from the app_user table.
• The value in this column will never change as a result of a Crowd user name change.