Make your own free website on

SAP Basis Components, Functional and ABAP Programming Books

Unix Oracle unlock/lock all users

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';

Back to Previous

Return to SAP Hints and Tips on Configuration and ABAP/4 Programming