Skip to main content
15-Moonstone
May 3, 2016 11:50 AM UTC
Solved

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

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

2-Explorer
May 3, 2016 12:28 PM UTC

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.

5 replies

2-Explorer
May 3, 2016 12:05 PM UTC

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

Translate
aachanta15-MoonstoneAuthor
15-Moonstone
May 3, 2016 12:14 PM UTC

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

Translate
2-Explorer
May 3, 2016 12:28 PM UTC

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.

Translate