jira修改登录用户名

在jira的数据库用户下执行如下SQL:

update cwd_user
set user_name = ‘new_username’, lower_user_name = ‘new_username’
where id =
(select id from cwd_user u where u.user_name = ‘old_username’);

update cwd_membership
set child_name = ‘new_username’, lower_child_name = ‘new_username’
where child_id =
(select id from cwd_user u where u.user_name = ‘old_username’);