Friday, October 21, 2011

SAP DDIC and SAP* unlock with SQL server

select * from ssd.USR02 where BNAME LIKE 'SAP*'


UPDATE ssd.USR02 SET UFLAG = 0 WHERE MANDT = '000' AND BNAME ='SAP*'




1. Unlocked status
2. Locked status

Change the "64" digit to "0" then "DDIC" and "SAP*" unlocked.

No comments:

Post a Comment