How to promote a regular DotNetNuke user to a superuser

I found this in Kevin Southworth's blog and I think it's worth mentioning since it may save your life in case you have forgotten your superuser's password. Using SQL, you can promote a regular DNN user to a superuser like this:

 

-- 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)

 

Simply replace 'theUsernameToPromote' with the user name you need.

 

Thanks Kevin!