What if I change the username in Sitecore using SQL command?
UPDATE dbo.aspnet_Users WITH (ROWLOCK)
UserName = @NewUserName
UserName = @UserName
I tried it and found that I can't see all other user data anymore (see screen shot). But the data does exist in core database.
What could be the issue?