What are all the SQL Tables to be modified or the procedure if we want to change a JIRA username

[JoseM]

Hello

We changed the username of a user in JIRA but when filled his timesheet, we notice in the table [jiradb]. [Jiraschema]. [Worklog] that it is his old trigram that is displayed. What is the procedure for changing the username of a user or what are all the SQL Tables to be modified ?

JIRA v7.10.0

Tempo Timesheets - 8.12.1 

Thank you

[Joe Pitt]

Directly updating the JIRA database is never a good idea. There is no published schema and things are spread out all over. You may never get it straightened out. 

[JoseM]

Hi Joe, we just changed the username in Active Directory. No updates were made directly to the database

[Craig Castle-Mead]

The username is stored as a string in many many tables. Your user management setup (local users, Crowd backed etc) and config settings in each can have a big impact on how cleanly a rename propagates. If you can give some background on your user directory setup, the community might be able to provide a solution.

CCM

[JoseM]

To be more specific I would like to know why when we changed the username, on the table [jiradb]. [Jiraschema]. [Worklog] we continue to have the old username. what must be done for the new username name to replace the old one?

[Craig Castle-Mead]

Hi JoseM,

So it sounds like you renamed the user in the database directly. The user admin UI supports renames, so wondering if you attempted to use that first instead of jumping straight in to the database?

There's also an app_user table which is very important when it comes to usernames/renames.

CCM

[JoseM]

Hi Craig, we just changed the username in Active Directory. No updates were made directly to the database