topic Re: Fields in USR02 table ? in Application Development and Automation Discussions

Fields in USR02 table ?

Former Member — Wed, 18 Jul 2007 18:51:35 GMT

What is the significance of TRDAT (Last logon date) column of USR02 table ? For any user if these column shows 00/00/0000 does it mean that this user has <b>"never logged in to that system"</b> after creation of his id ?

Whether any lock/unlock,password reset etc activities can reset TRDAT value to 00/00/0000 ?

Re: Fields in USR02 table ?

Former Member — Wed, 18 Jul 2007 18:56:31 GMT

sapman,

USR02 fields PWDLGNDATE PWDSETDATE are updated when a users password is changed.

Cheers,

Ben

Re: Fields in USR02 table ?

Former Member — Wed, 18 Jul 2007 18:58:19 GMT

yes 00/00/0000 has not logged on directly

Re: Fields in USR02 table ?

Former Member — Wed, 18 Jul 2007 20:11:25 GMT

If a user has logged on and then their password is reset or lock / unlock, it will not change the values in TRDAT. Only way to get those values back to 00/00/0000 is to delete and re-create the user .

Re: Fields in USR02 table ?

Wolfgang_Janzen — Fri, 20 Jul 2007 15:25:32 GMT

Please use only the available APIs.

Never (try to interpret or) evaluate contents of database tables.

The structure of table USR02 has been changed many times - and will continue to be subject of changes.

PS: do not pay much attention to those who pretend to be "experts" - believe me: they do not know all the internals which are required to implement it the right way.