How do I delete a user V4.5.1h (Build 1104)

[whyzer]

When installing I made the error of loading all the sample data. How do I delete the "sample" users???

Thanks

[SamuelAugy]

You con't do this but you can set users in Inactive status. It's a protection because usually user's are assigned to others objects.

[whyzer]

Not exactly the answer I was looking for. I had already set them to inactive I was trying to tidy things up a bit.

Thanks

[kuske]

In a SugarCRM 4.5.1.h installation you can recognize the demo user data on the id of the users table entries.

user admin has always id = 1
demo users have ids like jim_id, chris_id ,..
normal users have timestamp ids like 14bdd19b-dda6-ba25-e68d-475d646cabab

So you can delete alle demo data in mySQL QueryBrowser by doing the following:

1. delete all customfield table entries in tables *_cstm.

example (accounts):

delete from accounts_cstm 
where id_c in  
  (select id from accounts where assigned_user_id like '%_id');

2. delete alle reference table entries

example (accounts x contacts):

delete from accounts_contacts 
where account_id in
   (select id from accounts where assigned_user_id like '%_id');
delete from accounts_contacts 
where contact_id in
   (select id from contacts where assigned_user_id like '%_id');

3. delete all audit table entries

example (accounts):

delete from accounts_audit 
where parent_id in 
  (select id from accounts where assigned_user_id like '%_id')
or created_by like '%_id';

4. delete all standard object table entries

example (accounts):

delete from accounts where assigned_user_id like '%_id';

5. finally delete all demo users

example:

delete from users where id like '%_id';

BEFORE you start make a BACKUP of your database!!!

DO NOT START WITHOUT BACKUP !
DO NOT START WITH RUNNING WEB APPLICATION!