Data Table: usr02 (logon data)

This table stores logon information for SAP users.
As you can see, five historical passwords are recorded here. When you change the password, the system prompts that you are not allowed to use the first five passwords that have been used.
User Type ustyp can be seen in su01 user management.
The user flag records the user's lock status.

Mandt clnt 3 0 Client
Bname xubname char 12 0 user main record user name
Bcode xucode raw 8 0 password Space
Gltgv xugltgv DATs 8 0 user valid from
Gltgb xugltgb DATs 8 0 valid
Ustyp xustyp char 1 0 user type (a dialog, B system user (internal RFC and background processing), c Communication user (external RFC), L reference user, s service user)
Class xuclass char 12 0 user main record maintenance User Group
Locnt xulocnt int1 3 0 is the incorrect registration count for each user
Uflag xuflag int1 3 0 user flag (0 not locked-normal unlocked, 32 locked globally by Administrator-globally locked by Administrator, 64 locked locally by Administrator-locally locked by Administrator, 128 locked due to incorrect logons (limited term) -An incorrect logon is locked)
Accnt xuaccnt char 12 0 subject ID
Aname xuaname char 12 0 name of the creator of the user master record
Erdat xuerdat DATs 8 0 creation date of user master record
Trdat xuldate DATs 8 0 last registration date
Ltime xultime TIMS 6 0 last registration time
Ocod1 xucode raw 8 0 password Space
Bcda1 xubcdat DATs 8 0 password last changed date
Codv1 xucodevers char 1 0 EncryptionAlgorithm Of Code Version
Ocod2 xucode raw 8 0 password Space
Bcda2 xubcdat DATs 8 0 password last changed date
Codv2 xucodevers char 1 0 encryption algorithm code version
Ocod3 xucode raw 8 0 password Space
Bcda3 xubcdat DATs 8 0 password last changed date
Codv3 xucodevers char 1 0 encryption algorithm code version
Ocod4 xucode raw 8 0 password Space
Bcda4 xubcdat DATs 8 0 password last changed date
Codv4 xucodevers char 1 0 encryption algorithm code version
Ocod5 xucode raw 8 0 password Space
Bcda5 xubcdat DATs 8 0 password last changed date
Codv5 xucodevers char 1 0 encryption algorithm code version
Versn xuversion char 3 0 user master record version
Codvn xucodevers char 1 0 encryption algorithm code version
Tzone tznzone char 6 0 Time Zone
Zbvmaster char 1 0 CUA user template: logon not possible here
Passcode hash160x raw 20 0 hash value (160 bits)
Pwdchgdate xubcdat DATs 8 0 password last changed date
Pwdstate int1 3 0 planned: password change mandatory/optional
Reserved int1 3 0 reserved for future extensions

Among them, we often use the locnt and uflag fields. Each time the user enters the locnt field with the wrong password, the value will be increased by 1. If it accumulates for a certain number of times, the user is locked and cannot log on. It must be unlocked by the user administrator. uflag records the user's lock status. If it is 0, the user can log on normally. Otherwise, the user cannot log on.

If you have installed a system on your own, but failed to log on multiple times because you do not know the initial password, you can use the database management tool to open the usr02 table and restore the two values to 0, to log on again.

 

◎ Please note thatProgramPersonnel must abide by the basic professional ethics of "do not do evil". These extreme practices can be used only when they are practiced and approved by the relevant leaders. Do not abuse them.