cancel
Showing results for 
Search instead for 
Did you mean: 

Regardig query in database

Former Member
0 Kudos

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

View Entire Topic
Former Member
0 Kudos

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
0 Kudos

Hi Umesh

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

Regards

Sanjeev.S

Former Member
0 Kudos

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