To unlock or lock all users
From Unix Oracle
If you accidentally locked all the users including SAP*
and DDIC in one of the clients.
This is another method to UNLOCK ALL users.
Start Oracle Server manager ( I assume you are on Oracle)
connect internal
update sapr3.usr02 set uflag='0' where mandt='399';
When users are locked, the uflag is set to 64.
Finish, just query to check.
select bname, uflag from sapr3.usr02 where mandt='399';
SAP Basis Reference Books:
SAP
Basis Components, System Administration, Security, ALE and iDoc Books
Back to Basis Menu:
SAP BC (Basis Components)
Hints and Tips
Return to :-
SAP ABAP/4 Programming,
Basis Administration, Configuration Hints and Tips
(c) www.gotothings.com All material on this site is Copyright.
Every effort is made to ensure the content integrity.
Information used on this site is at your own risk.
All product names are trademarks of their respective
companies. The site www.gotothings.com is in no way affiliated with
SAP AG.
Any unauthorised copying or mirroring is prohibited.
|