how to delete users (and yes I know about invalid)

Hi folks, I understand the point about not deleting users as described here: http://doc.otrs.org/2.0/en/html/x694.html 'To keep the consistency of the data for OTRS it is not possible to delete a user. To deactivate a user account set it to "invalid" or "invalid-temporarily".' I am just at the very beginning of my installation, and testing out LDAP integration to an Active Directory server. I am trying to use AuthSyncModule::LDAP::UserSyncInitialGroups so that once a user is authenticated, it automatically transfers their user information from LDAP to the OTRS database, AND (what UserSyncInitialGroups does specifically) adds them to the 'admin' group. However when I first tested this I had it set only to add them to the 'users' group. And it seems like it ony does this step on the very first time the user logs in. So now to test that it correctly adds a user to the 'admin' group the first time they log in, I really think I do need the user delete capability, so that my test user can log in for the "first time" again. This is an Ubuntu 10.04 system, with otrs 2.4.7-1ubuntu0.1 and postgresql 8.4.7-0ubuntu0.10.04. So I guess the question is probably, can I just use the psql command line client, and delete the relevant rows (say, for user id 2 if that's the one I want to re-test) from the Postgres tables 'users', 'user_preferences', and (if that was indeed the highest user id and I want it to get re-used when the user is added again) update the last_value column in the 'users_id_seq' table. Is this the right approach or are there too many other tables that would need to be kept consistent for this to work. Note that I have not manually added any users to any groups, I have not added any tickets, roles, or anything else. All I have done since the install is test this user login stuff, and view (not change) things. Thanks in advance for any suggestions. Martin
participants (1)
-
marthter