Changing usernames

On this page

Still need help?

The Atlassian Community is here for you.

Ask the community

The script below has been used by an Atlassian customer to change a username in Bamboo 3.1. No guarantees are implied by its presence here.

update ACL_ENTRY set SID='newusername' where SID='oldusername';
update ACL_OBJECT_IDENTITY set OWNER_SID='newusername' where OWNER_SID='oldusername';
update AUDIT_LOG set USER_NAME='newusername' where USER_NAME='oldusername';
update AUTHOR set LINKED_USER_NAME='newusername' where LINKED_USER_NAME='oldusername';
update AUTHOR set AUTHOR_NAME='newusername' where AUTHOR_NAME='oldusername';
update AUTH_ATTEMPT_INFO set USER_NAME='newusername' where USER_NAME='oldusername';
update BUILDRESULTSUMMARY_CUSTOMDATA set CUSTOM_INFO_VALUE='newusername' where  CUSTOM_INFO_VALUE='oldusername' && CUSTOM_INFO_KEY='ManualBuildTriggerReason.userName';
update BUILDRESULTSUMMARY_LABEL set USER_NAME='newusername' where USER_NAME='oldusername';
update LABEL set NAMESPACE='newusername' where NAMESPACE='oldusername';
update NOTIFICATIONS set RECIPIENT='newusername' where RECIPIENT='oldusername';
update REMEMBERME_TOKEN set USERNAME='newusername' where USERNAME='oldusername';
update USER_COMMENT set USER_NAME='newusername' where USER_NAME='oldusername';
update external_entities set name='newusername' where name='oldusername';
update users set name='newusername' where name='oldusername';
Last modified on Sep 13, 2017

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.