how can we lock/unlock all sap users from OS level

[Former Member]

hai friends,

how can we lock/unlock all users from OS level and from sap screen ,pls explain me with detail...

[Rudi_Wiesmayr · Accepted solution]

SE38 "EWULKUSR" Go!

This useful program is a spinoff for the EURO conversions in Europe.

It 's there since 4.x times and is an invaluable tool for our maintenance activities, where only SOME users are allowed to work on the system.

HTH + dont forget to point...

Rudi

[Rudi_Wiesmayr · Accepted solution]

OK, it 's from inside the running system. But that 's the only "good" way.

From the OS level you only have the chance to change the database contents. This hack is possible, sure. But it depends on your company policies if it 's legal.

Kind regards, Rudi

[Former Member · Accepted solution]

let me explain how can we unlock from OS level...

[former_member204746 · Accepted solution]

You need to do an SQL command and change field UFLAG in table USR02:

create table sapr3.USR02_backup from select * from sapr3.usr02;

update sapr3.usr02 set UFLAG='64';

update sapr3.usr02 set UFLAG='0' where bname='YourUserName'

you will need to reset buffers in SAP or restart your system if using WAS 6.x and above.

<b>DO THIS AT YOUR OWN RISKS. I HAVE NOT TESTED THIS SCRIPT.</b>

[Former Member]

The answer you are looking for is tp locksys <SID> and tp unlocksys <SID>

[markus_doehr2]

you can from SAP level using transaction EWZ5, not possible from OS level (why would you want to deal on operating system level with application users?)

--

Markus

[Former Member]

if i lock all users from sap level ( with ddic ,sap*) .how can we enter in to sap sys...pls inform me how to unlock users from OS level...