Logging TCMS Users

This one comes from my replacement at COF: Russ, but I've heard requests for this functionality at TAUG.

So you want to track customer logins to TCMS, but the only information stored in the WEB_USER table is their last login. If you put a trigger on that table to populate a log table (or even CUS_ACTIVITY) every time the last login time changes, you've done it as this field is updated every time the customer logs in.

Not only can you track the logins, but using the same methodology you can track changes to user names and passwords also stored in that table. You can also track the MODOPER to see who made the change: the customer or a staff member.

Applies to: TIMSS6 & Personify