Regardig query in database

[Former Member]

Hi all

If all the users were locked in SAP system and we were unable to log to the

sap ..

I think we will be running a query ,which resets the lock for DDIC users,

Can any one please tell me what is the query which we run in database and

also the name of the table which i affected by running that query

Regards

sanjeev.S

[Former Member · Accepted solution]

Hi,

u can login via sap* or ddic to login..if these users are locked u have to set the uflag of usr02 table with 0

regards

Umesh K

[Former Member · Accepted solution]

Hi Umesh

Thanks for your reply. Can please explain me more in detail about it

Regards

Sanjeev.S

[Former Member · Accepted solution]

Hi

sqlplus /nolog

SQL>connect / as sysdba

SQL>update sapr3.usr02 set uflag = '0' where bname = '<userid>' and mandt = '<client>' ;

SQL>commit ;

uflag=64 means user is locked and 0 means unloacked

Regards

Umesh K