Looking for Datastage user related info

Saha · Post by **Saha** » Tue Apr 08, 2014 6:05 am

Hi All,
I wanted to know in what all Xmeta tables DS user information (like-password,last login time etc.) are stored.
Thanks in advance!!

ray.wurlod · Post by **ray.wurlod** » Tue Apr 08, 2014 2:03 pm

That information is not documented.

stuartjvnorton · Post by **stuartjvnorton** » Tue Apr 08, 2014 5:18 pm

Login activity is not stored there.

You can refer to your equivalent of /opt/IBM/WebSphere/AppServer/profiles/InfoSphere/logs/ISauditLog.log (may differ a bit according to audit settings) to get all login/logout activity and the client used.

General user info (name, email, etc) is stored in <XMETA_SCHEMA>.ASCLMODEL_XMETAGEN_USERB1C497CE.
Can't remember if password is in there. Even if it is, it would be encrypted.

Saha · Post by **Saha** » Wed Apr 09, 2014 3:26 am

Hi stuartjvnorton,
Thanks for the information...I can see the log file in DS 8.5 and got required information...what will be its equivalent file in 8.1 and 7.5 ? any idea?

chulett · Post by **chulett** » Wed Apr 09, 2014 8:06 am

No such equivalent in the 7.5 world.