Confluence Docs 3.0 : Changing Usernames This page last changed on Mar 09, 2009 by ggaskell. A username is the name used to log into Confluence, eg. `jsmith`.
| Currently, there is no straightforward method for changing a username and its associated content, to that of another user. The only practicable method currently available is to execute direct SQL queries on your database. There is a feature request to facilitate this process via a web interface and you can vote for it to improve its chances of being implemented. Be aware, however, that no matter what method you use to change usernames in Confluence, there is no support provided for this process. The instructions below provide suggested guidelines on how to change a username via SQL queries, although this may vary depending on your database.
### Instructions For Changing Usernames
| The following SQL commands are only tested for MYSQL and POSTGRES Databases. If you have any other database please contact your DBA to determine the equivalent queries.
4. Usernames can only be changed through direct update to the Confluence database. If you have a database administrator, request that they approve the database-related steps described below If you are using JIRA user management, Revert from JIRA To Internal User Management Backup Confluence Creating a `usermigration` table:
       create table usermigration
       (
       oldusername varchar,
       newusername varchar
       )
5. Usernames that will be changed must be placed in the `usermigration` table with their current and planned usernames:
       insert into usermigration (oldusername, newusername)
       values ('oldusername', 'newusername');
6. If your DB administration tool does not support multiple SQL queries, these must be entered individually.
       update attachments
       set creator = newusername from usermigration u
       where creator = u.oldusername;

       update attachments
       set lastmodifier = newusername from usermigration u
       where lastmodifier = u.oldusername;

       update content
       set lastmodifier = newusername from usermigration u
       where lastmodifier = u.oldusername;

       update content
       set creator = newusername from usermigration u
       where creator = u.oldusername;

       update content
       set username = newusername from usermigration u
       where username = u.oldusername;

       update extrnlnks
       set creator = newusername from usermigration u
       where creator = u.oldusername;

       update extrnlnks
       set lastmodifier = newusername from usermigration u
       where lastmodifier = u.oldusername;

       update label
       set owner = newusername from usermigration u
       where owner = u.oldusername;

       update content_label
       set owner = newusername from usermigration u
       where owner = u.oldusername;

       update links
       set lastmodifier = newusername from usermigration u
       where lastmodifier = u.oldusername;

       update links
       set creator = newusername from usermigration u
       where creator = u.oldusername;

       update notifications
       set lastmodifier = newusername from usermigration u
       where lastmodifier = u.oldusername;

       update notifications
       set creator = newusername from usermigration u
       where creator = u.oldusername;

       update pagetemplates
       set lastmodifier = newusername from usermigration u
       where lastmodifier = u.oldusername;

       update pagetemplates
       set creator = newusername from usermigration u
       where creator = u.oldusername;

       update spaces
       set creator = newusername from usermigration u
       where creator = u.oldusername;

       update spaces
       set lastmodifier = newusername from usermigration u
       where lastmodifier = u.oldusername;

       update spacepermissions
       set permusername = newusername from usermigration u
       where permusername = u.oldusername;

       update spacepermissions
       set creator = newusername from usermigration u
       where creator = u.oldusername;

       update spacepermissions
       set lastmodifier = newusername from usermigration u
       where lastmodifier = u.oldusername;

       update contentlock
       set creator = newusername from usermigration u
       where creator = u.oldusername;

       update contentlock
       set lastmodifier = newusername from usermigration u
       where lastmodifier = u.oldusername;

       update os_user
       set username = newusername from usermigration u
       where username = u.oldusername;

       update trackbacklinks
       set creator = newusername from usermigration u
       where creator = u.oldusername;

       update trackbacklinks
       set lastmodifier = newusername from usermigration u
       where lastmodifier = u.oldusername;
7. If using Confluence 2.1 or newer, run the following command:
       update users
       set name = newusername from usermigration u
       where name = u.oldusername;
8. Reassign personal spaces and content associated with the old username to the new username. The tilda (~) is required as it is prepended to the space key of all personal spaces.
       update spaces
       set spacekey = '~newusername'
       where spacekey = '~oldusername';

       update content_label
       set spacekey = '~newusername'
       where spacekey = '~oldusername';

       update bandana
       set bandanacontext = '~newusername'
       where bandanacontext = '~oldusername';
Each username is associated with a full name. For example, username 'jsmith' may have a full name of 'John M Smith'. If this fullname needs to be changed, modify the fullname in the `users` or `os_user` table. All old usernames in Confluence should now be replaced with the new usernames from the `usermigration` table. ##### RELATED TOPICS
Editing User Details
Global Groups Overview
Viewing members of a group
Troubleshooting LDAP User Management
Enabling or Disabling Public Signup
Adding or Removing Users in Groups
Adding a Group
Removing a Group
Searching For and Managing Users
Adding a New User
Setting up Anonymous Access
Changing Usernames
Disabling the Built-In User Management
Global Permissions Overview
Removing a User
Showing first 15 of 16 results

Document generated by Confluence on Nov 05, 2009 23:27