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!
To update the user account simply run the below script, be sure to put your username in for the username.
Thanks for this.Although I'm not sure this is quite enough to get the user to full superuser status.When I applied this to a user account they still remained listed in the portal user list rather than in the superuser list - so they can still be deleted by portal admins...To fix this (looking at the source for DotNetNuke.Modules.Admin.Users.UserAccounts) I think you'd need to delete the relevant userId from the PortalUsers table - but I've not tried this yet!
Yes, you are correct!
I am honestly surprised that DNN doesn't allow you to assign this role if you are a host user. It could spell trouble for those not adapt at SQL like myself. Unles there is a way to give module upload access to an admin?
Dean,I would agree to a certain extent....but the permissions granted with host access are so great, that in my opinion it should be external to normal roles.You can create a new Host user easily via the "Host Accounts" menu options.
Thank you for this...I wish I could also say that I was surprised that this wasn't an option, but then I remembered that DotNetNuke is a horrible pos, and I became no longer surprised. ;)Thanks again!
How do I take a SuperUser and make them a normal user on a portal?
What would be the process for doing this for the current DNN version (5.6?). Updating the user table seems to be the same, but there is no portalusers table from which to remove the users. As a result, my promoted user is not showing up in the list of super users.
Name (required)
Email (required)
Website
Notify me of followup comments via e-mail
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.
Subscribe To Blog RSS Subscribe To Blog Updates by E-Mail * Add to Technorati Favorites
Click here for advertising information.
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.