Subscribe to my RSS feed
|
|
HowTo: Promote a regular DotNetNuke user to a SuperUser
The other day I needed to promote a regular DotNetNuke user account to a "SuperUser" account and couldn't find any info on how to do it. Well it turns out it's quite easy if you can run a quick SQL script on your DNN database. Here's all it takes:
-- Promote regular user to SuperUser
declare @username varchar(50)
set @username = 'theUsernameToPromote'
UPDATE Users SET IsSuperUser = 1 WHERE username = @username
DELETE FROM UserPortals WHERE UserId = (SELECT UserID FROM Users WHERE username = @username)
Run the script above on your DNN database and whoila!
| Comments |  BySotiris Filippidis @
Thursday, November 27, 2008 6:02 AM |
Excellent. I'd like you to know that I have republished this at http://dnnuke.blogspot.com with a reference to the original source, of course.
|
|
|
You must be logged in to post a comment. You can login here |
|