I came across a situation today where I wanted to change usernames of a set of users within my web app. I created a list of around 20-30 administrative users all with usernames based on the location of their office. However, I’ve now been advised that these usernames would be better stored as 2 letters. This would certainly make login easier for the administrative users, but I now have the task of either deleting them all and starting again or finding some other way of renaming the usernames.
After a quick google, I’ve noticed there is no quick way of doing this apart from this method described here:
Maybe this will be something that will be added in future versions of ASP.NET?!
Today, I had to go through all the usernames and change them, and all I ended up doing was using the Database editor (in t his case myLittleAdmin) provided by my web hosting company.
It was as simple as clicking on the aspnet_Users table and then modifying each row, in particular the UserName and LoweredUserName fields. You could even create some SQL to go and update each row based on some other piece of data perhaps?
