Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

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

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...are these tables ok for clearing out users?are these tables ok for clearing out users?
Previous
 
Next
New Post
6/28/2010 2:20 PM
 
Hello All,

I have to do some testing of import and create of users in the next few days, and I will be playing with creating 15,000 users.  I will be using a module that will create the users for me using DNN Code, but once they are created, I need to trash them again.

As far as I can see, I need to delete my users from the following tables.  But Do I need to look elsewhere?  I know that there might be the odd reference to their userid, someplace but in general these users never even logged in.  I am not proposing to whack the tables like this as best practice but I do want to ensure that I do not miss a table with another full set of the users I import

Thanks in advance for your comments.


These are the tables I intend to whack:

aspnet_Membership

aspnet_Users

UserRoles

UserProfile

UserPortals

Users

UserAuthentication ==> NO records IN my Database




Mark Breen Ireland 1987 BMW R80 g/s
 
New Post
6/28/2010 3:28 PM
 
AFAIK these should be all tables, besides entries in permissions tables (folderpermissions, modulepermissions, tabpermissions) with userID not null

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
6/29/2010 5:32 AM
 
Thanks a lot for the quick reply Sebastian, Mark

Mark Breen Ireland 1987 BMW R80 g/s
 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...are these tables ok for clearing out users?are these tables ok for clearing out users?


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.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out