Changing User Name

To change a user name which has been entered incorrectly the database needs to be amended. This requires host level access, or access to the server.

The tables to be amended are:

Users

Change the entry in the column UserName

UPDATE aspnet_Users
SET UserName = 'myUserName',

aspnet_Users

Change the entry in the columns UserName and LoweredUserName

UPDATE aspnet_Users
SET UserName = 'myUserName',
SET LoweredUserName= 'myUserName',

Note that care should be taken to ensure that the revision to the username does not cause a conflict with another user name.

NAT January 2008