Hi,

We are using DNN5 for our intranet.

A lot of our custom functionality (modules) depends on user roles, so it is imperative users belong to the right roles.

However, due to some mishaps over the last weeks, we ended up with most users’ belonging to the wrong roles.

While we figured out why this happened and how to prevent this in the future we want to reset our user roles.

Now we normally use the Bulk Import Module to import users.  We had someone create us a new file with all users, and their correct roles.

My thoughts for the moment are to clear out the UserRoles table as well as the Roles table (leaving to the latter only the Administrators, Registered Users and Subscribers roles.

Then run the import which will/should (1) create any role it encounter that does not exists and (2) assign the user to the roles listed for the user in the import file.

Figured I’ll investigate a bit and ask around before going ahead. Obviously do not want to mess things up (while I will have IT backup our database before running the above).