23

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..."

Post Rating

Comments

almny
2009年5月19日 4:45
thanks for this
i search about it
but i want to ask i cann't change dnn user name by updating UserInfo ??
Ariel Maioli
2010年5月18日 16:32
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')
Adam
# Adam
2011年8月16日 23:33
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

Post Comment

Name (required)

Email (required)

Website

CAPTCHA image
Enter the code shown above:

 
LatestArticles