Tuesday, January 13, 2009

More on changing a user name in dnn - in my environment

In my environment... also need (want) to update the displayname and the yaf name too.

Plus I'm using prefixes for my table names:

update dnn_users set username='newusername', displayname='newusername' where username='oldusername'
update aspnet_Users set username='newusername' ,loweredusername='newusername' where username='oldusername'
update yaf_users set name = 'newusername' where name='oldusername'

No comments:

Post a Comment