Unable to remove user in Windchill

[kchaithanya]

Hi All,

Good Day To You..

I've removed Windchill  existing user normaly. But, still that user is existing in products context. I've checked in LDAP, where no such user was observed.

But, from SQL Server, by executing a query, I've found that user from WTUser table.

I need your help for permanently remove that user.

Thanks And Regards

Krishna Chaithanya

[HugoHermans]

Hi Krishna,

Apart from your question, do you think it's a good practice to remove a user from Windchill? I never do that.  I deactivate them, but don't remove.

Hugo.

[TomU]

Deleting a user from Windchill does not remove all references to them from the system.  While their information is completely removed from the LDAP, some information is preserved in the database.  From my testing:

• When a user is created, the following tables have new records (rows) created:
  • Cabinet
  • OwningRepositoryLocalObject
  • RemoteObjectId
  • RemoteObjectInfo
  • SubFolder
  • SubFolderLink
  • SubFolderLinkConstraint
  • WTUser

• When a user is deleted from Windchill, the following steps occur:
  • Records are deleted from these tables:
    • OwningRepositoryLocalObject
    • RemoteObjectId
    • RemoteObjectInfo
  • User’s record in WTUser is altered:
    • ‘Disabled’ is changed from ‘0’ to ‘1’
    • The name is prefixed with “{wt.org.WTUser:<idA2A2>}”

For example, user named ‘tom’ becomes ‘{wt.org.WTUser:123456}tom’

• I haven’t tested this yet, but I’m guessing the remaining records in the subfolder tables will be deleted when the user’s personal cabinet is removed (using personal cabinet administrator).

What does this mean?

• If a user is deleted from Windchill and later they are re-added (either intentionally or unintentionally through group membership, etc.) they will show up in Windchill as a new user.   This means when searching by participant, two distinct users with the same display name will show up, but one will have “Deleted” next to their name.  To prevent this, either the user should never be deleted or the “Name” and “Disabled” fields in the WTUser table must be manually updated prior to their account becoming accessible to the system again (visible in the LDAP).
• The user's entry in the WTUser table is preserved so that actions taken and objects created by this user are still linked back to them even though they are no longer able to create new objects.  For example, searching for the creator of a object will still list a deleted user, even after they've been deleted.
• If you want to remove all evidence of a user's name from the system, you will need to manually modify their record in the WTUser table and change any identifying information.  You could also do this prior to deleting the user by changing their username, email address, etc. to something non-identifying, then deleting them.