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.

 

Greg,

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

---