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!!
Looking for Datastage user related info
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
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.
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.