Corrupted user login organization

[CraigFinney]

I was creating a new user, which at the same time something crashed our method servers. The user was created with a domain, but not the organization. We are running a one Organization install. Now I cannot edit the user as Add Participants will only search the organization, nor can I add him as new as he already exists (I can see the user from a Windchill Report).

How do I either : 

• Edit the user? Either correct the organization or the domain to unaffiliated?
• Delete the user and start a fresh user.

[avillanueva]

Are you trying to edit the user at the Org level or site level participants administrator page?

[CraigFinney]

His organization did not complete set, so I cannot find him.  The Site is the next level below Org level.  Problem is the Domain did set, just not the ORG.  So WC will not allow me to find, nor create new.  And I check Site Utils and Org Utils options.

[mmeadows-3]

The user has never logged in.  I would just delete it.

Probably good to backup your participant tables first.

An example of deleting a user at the DB level is found in this article.

https://www.ptc.com/en/support/article/CS54747

This article explains the participant table relationships.

https://www.ptc.com/en/support/article?n=CS109367