Promoting DNN User to Super user

24 Feb

As someone pointed out on the DotNetNuke message boards, my previous example of creating a new host account via SQL is a bit over-involved in certain special cases. If you have an user account that you would simply like to promote to a host account it is a very simple single SQL Script. This process can be very helpful if you are looking to take for example your personal account and promote it to a host to fix errors. However, you want to be sure that you are careful which account you promote as anyone that would log in with this account after the change will have host permissions!

The Script

To update the user account simply run the below script, be sure to put your username in for the username.

UPDATE users
SET IsSuperUser 1
WHERE username 'TestUser'
tags: DNN, Tutorials, SQL
comments powered by Disqus

Content provided in this blog is provided "AS-IS" and the information should be used at your own discretion.  The thoughts and opinions expressed are the personal thoughts of Mitchel Sellers and do not reflect the opinions of his employer.

Connect with Mitchel

I hope the information here has been helpful. To stay connected you can also subscribe to blog updates via email, contact Mitchel about consulting services, or reach out for assistance via CodeMendor

Content Copyright

Content in this blog is copyright protected.  Re-publishing on other websites is allowed as long as proper credit and backlink to the article is provided.  Any other re-publishing or distribution of this content is prohibited without written permission from Mitchel Sellers.