How do delete registered users?

[ascll]

Greetings,

If the database already uploaded, anyway to delete certain users?

As far as I known, deleting users will affected at least 4 tables, which
is: -

- aspnet_Membership
- aspnet_Profile
- aspnet_Users
- aspnet_UsersInRoles

Any table I miss out?


Question
How do totally delete users with Username like '%test%' from all affected
tables?


Kindly advise.

Thanks
ascll

 

[Steve]

The easiest way to do this is via code in an ASP page, not SQL:
foreach (MembershipUser mu in Membership.GetAllUsers()) {
if (mu.UserName.IndexOf("test") >=0 ) {
Membership.DeleteUser(mu.UserName);
}
}

If you want to do this directly in SQL server, don't manually modify the
tables; instead, use the stored proc: aspnet_Users_DeleteUser.

Steve