SAP user lock problem

Home


To update password at oracle level

update SAPECC.usr02 set bcode= 'XXXXXXXXXXXXX' where bname= 'DDIC' and mandt= '000';

if you know any user password, take it from --se16-usr02-BNAME -choose Bcode

-----------------------------------------------------------------------------------
To delete sap* at oracle level

SQL> Delete from SAPECC.usr02 where bname = 'SAP*' and mandt = '000';

1 row deleted.

----------------------------------------------------------------------------------

Below is the query for resetting the flag

SQL> update SAPSR3.USR02 set UFLAG=0 where MANDT = ’000′ and bname= ‘DDIC’;
SQL> commit;

------------------------------------------------------------------------------------
TO check DDIC user status ;
SQL> select BNAME, MANDT, UFLAG from SAPSR3.USR02 where BNAME=’DDIC’;