Learn More





Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Manually Insert UsernameManually Insert Username
New Post
4/24/2013 2:25 PM

So I've been on a quest to manually install a username under a particular custom role I've developed.  This role restricts Administrator function; so essentially we are restricting our users initial control.

 I found the following tables:

  • [dbo].[aspnet_Users]
  • [dbo].[Users]
  • [dbo].UserPortals
  • [dbo].[aspnet_Membership]

Those appear to be the tables I require to insert my own custom information.  The downfall that I've found is Dot Net Nuke does some encryption on the password.

  •  Password
  • PasswordFormat
  • PasswordSalt

Those are the columns in question. When I directly insert raw syntax values into the database Dot Net Nuke does not encrypt the data.  Does anyone know in the API or the best approach to accomplish this task?

Or is the difficult route I'm going the undeniable pain I must endure to accomplish my task.  I need to find that encryption; so I can physically manually enter these Usernames with given profile information.


New Post
4/24/2013 7:13 PM

You should avoid working with tables directly - instead take a look at the DNN api - there are functions there that handle the registration on new users.


New Post
4/25/2013 5:16 AM

if there is some reason to create a bunch of users, and you do not want to use the UI, then you can

- look for a module that allows bulk inserts of users (I don't know if there is one)
- create one user using the api with a password you know and use this password hash for all the inserted users. Make sure you set the option that the user has to change the password when he is logging in for the first time. After you did that, clear the cache and recycle the AppPool from the Tools menu.

Anyway, I agree with Wes - you should avoid this second option. But if you do so, do it on a testing environment before you do it on your production server. And backup your site and database before...

Best wishes

Michael Tobisch
DNN★MVP - Michael Tobisch's Site about DNN, SQL Server, ASP.Net and other related stuff - The most vibrant community around the DNN-platform
New Post
4/25/2013 11:46 AM
Well, we have a specific need.  I've been looking at the API and it does indeed have functionality that should meet my needs it looks like.  I'll have to ensure that it also falls into the proper relationship to handle the permission.
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Manually Insert UsernameManually Insert Username

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
Try Evoq
For Free
Start Free Trial
a Demo
See Evoq Live
Need More Information?