Hey Jeff,

The ability to delete users went away in 2.0 and on. We're working on re-incorporating the function in a future feature release, but it is currently not available in 2.0.x or 2.5.x.

If it is absolutely critical for you to delete these users, you'll want to follow these steps:

1. Back up the database
2. Remove all content for a user from the front-end UI (blog posts, messages, document versions, etc.)
3. Run the following queries (after stopping the application). This query will delete all disabled users ... make sure to change the where condition if you're not trying to delete all disabled users:
   
   1. delete from jiveUserContainer where userID in (select userID from jiveUser where userenabled=0);
      
   2. delete from jiveUserRel where userID in (select userID from jiveUser where userenabled=0);
      
   3. delete from jiveUserRel where  relateduserID in (select userID from jiveUser where userenabled=0);
      
   4. delete from jiveptracker where userID in (select userID from jiveUser where userenabled=0);
      
   5. delete from jiveUser where userenabled=0;
      
4. Start up the database

Please note that this operation is not supported and if you have any issues with this, we will immediately advise you to revert to your backed up database.

Thanks,

Vinh

Where ever you see "userenabled=0" change it to "userid in (?, ?, ?)" where the ? represents the user IDs.

Hey Nils,

You will be able to delete users in the 3.0.x release.

Thanks,

Vinh