Skip to main content
15-Moonstone
May 3, 2016
Solved

In which table are the Windchill user credentials are stored in Database ?

  • May 3, 2016
  • 1 reply
  • 2778 views

Hi All,

In which table are the Windchill user credentials stored in Database ? Is it WTUser or any other table ?

And within Windchill DS as well we can see the user name, password email etc. So in which other table it does store ?

Can you please let me know.

Thanks and Regards,

Aditya Achanta

Best answer by BineshKumar1

All versioned objectshave a child table and a master table. So WTPart, there is a WTPart and WTPartMaster. Query the WTPart table for version and so on and WTPartMaster for name, number etc.

1 reply

1-Visitor
May 3, 2016

Windchill does not store password in database. It is stored in Windchill Directory Server. WTUser table store almost all the user details except password like full name, username, email, status and so on. Remoteobjectid table stores the dn of each user and it is used to locate the user in ldap. Remoteobjectinfo is where associated adapter info is stored.

Regards

Binesh Kumar

Medtronic - MITG

aachanta15-MoonstoneAuthor
15-Moonstone
May 3, 2016

Hi Binesh,

Thank you.

Where can we see the version, revisions or iterations in DB for a particular object like WTPart etc. ?

Thanks and Regards,

Aditya Achanta

1-Visitor
May 3, 2016

All versioned objectshave a child table and a master table. So WTPart, there is a WTPart and WTPartMaster. Query the WTPart table for version and so on and WTPartMaster for name, number etc.