Documentation for Bamboo 4.0.x. Documentation for earlier versions of Bamboo is available too.

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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';
  • No labels