Hi, I have a couple of Crucible users who have left the company and come back, or who have switched domains within the company, and they have been unable to login to Crucible. Their accounts were removed (using the Crucible UI), but then we have tried to create new accounts for them using their ID (which has remained the same throughout their moves). Creating a new account was unsuccessful as Crucible says they're already in the system ("a user with that name already exists"). Yet when they try to log in, they get an error ("password incorrect or unknown user"). We are integrated with LDAP, so we don't have any option to change user names to something other than what exists in LDAP. The issue seems to be that the users exist in the table CRU_USER even after they are removed (using the UI). I have tried to manually remove the row from CRU_USER, but there is an exception stating that there are child tables. However, the database spec does not mention what these child tables are, and I can't puzzle it out just by looking at the data.
Any ideas on how to get around this? Thanks!