Team,
We need to perform a user cleanup in our JIRA instance that uses SQL database. We would like to know if we can delete the users from databse table cwd_user directly.
Thanks.
Absolutely not.
Unless you are 100% sure you have captured and updated all the places a user id might have been used or it will try to refer to defunct user records and fall over in a steaming heap (you'll be reaching for backup tapes). 18 different tables last time I looked. Reporter, assignee, custom fields, watcher, voter, component and project leads, comments, the list goes on and on.
It would be far better to *attempt* to delete users with a Jelly script - that will delete users, but only the ones it is safe to delete
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.