Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Fields in USR02 table ?

Go to solution
Former Member

‎07-18-2007 7:51 PM

0 Kudos

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 ?

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎07-18-2007 7:58 PM

0 Kudos

yes 00/00/0000 has not logged on directly

4 REPLIES 4

Go to solution
Former Member

‎07-18-2007 7:56 PM

0 Kudos

sapman,

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

Cheers,

Ben

Go to solution
Former Member

‎07-18-2007 7:58 PM

0 Kudos

yes 00/00/0000 has not logged on directly

Go to solution
Former Member

‎07-18-2007 9:11 PM

0 Kudos

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 .

Go to solution
WolfgangJanzen
Product and Topic Expert
Product and Topic Expert

‎07-20-2007 4:25 PM

0 Kudos

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.