How to change dotnetnuke (dnn) username? > DNN Knowledge Base, DNN Tutorials, DNN Free Tutorials, DNN Hosting

How to change dotnetnuke (dnn) username?

host posted on 2007-23-09

I have sucessfully used the following script to change the dnn username (by going to host -> SQL):

================================================

update users set username='newusername' where username='oldusername'

update aspnet_Users set username='newusername' ,loweredusername='newusername' where username='oldusername'

================================================

Posted in: DNN "How to..."

Actions: E-mail | Permalink | Comments (3)

| Kick it! | DZone it! | del.icio.us

Comments

		thanks for this i search about it but i want to ask i cann't change dnn user name by updating UserInfo ??
@ 2009年5月19日 4:45 by almny

		Complete relations for this, with roles: SELECT dbo.Users.UserID AS UserID_Users, dbo.Users.Username, dbo.Users.Email, dbo.aspnet_Users.UserId AS UserId_ASP FROM dbo.UserRoles INNER JOIN dbo.Users ON (dbo.UserRoles.UserID = dbo.Users.UserID) INNER JOIN dbo.Roles ON (dbo.Roles.RoleID = dbo.UserRoles.RoleID) INNER JOIN dbo.aspnet_Users ON (dbo.Users.Username = dbo.aspnet_Users.UserName) INNER JOIN dbo.aspnet_Membership ON (dbo.aspnet_Users.UserId = dbo.aspnet_Membership.UserId) WHERE (dbo.Roles.RoleName = 'blablabla')
@ 2010年5月18日 16:32 by Ariel Maioli

		An even better way is: DECLARE @oldusername nvarchar(100) = 'OldUserName'; DECLARE @newusername nvarchar(100) = 'NewUserName'; update users set username=@newusername where username=@oldusername update aspnet_Users set username=@newusername ,loweredusername=LOWER(@newusername) where username=@oldusername
@ 2011年8月16日 23:33 by Adam