Skip to Content
avatar image
Former Member

Fields in USR02 table ?

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 ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 18, 2007 at 06:58 PM

    yes 00/00/0000 has not logged on directly

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 18, 2007 at 08:11 PM

    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 .

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 18, 2007 at 06:56 PM

    sapman,

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

    Cheers,

    Ben

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 20, 2007 at 03:25 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded