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

Question

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

JoseM · Answer

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

JoseM · Answer

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

Joe Pitt · Answer

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.