on 07-12-2022 10:21 AM
I have locked all User-IDs in one client.
I can access the DB.
How to unlock one to get access again?
Dear admin,
as you have access to the database, you can unlock your own ID and log on again with your former password.
The user lock is stored in table usr02, field uflag. The current value is 64 (or 32, 128 or a combination of that values), means the user is locked. If you set this value to 0 again with DB-tools , you will be able to log on again and unlock all other IDs then.
Please note, that the change logs for your ID won't show that unlocking of course, but at the next change to your ID the unlock will appear at the next change.
Please note, that this approach is not supported by SAP.
For the correct SQL command please consult your DB-admin, as it may differ from DB-to DB-vendor.
Good luck,
Bernhard
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
74 | |
26 | |
11 | |
10 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.