How to unlock and reset Sap* and DDIC users

ABAP system running on Sybase ASE Server

Login to Sybase ASE database using following command with Windows Command Prompt

isql -Usa -S<SID>

It will prompt for password

1> use <DBSID>
2> go

 

To check the account status for SAP*

1> select UFLAG from USR02 where BNAME ='SAP*' and MANDT='xxx'
2> go

To unlock the SAP* account

1> update USR02 set UFLAG=0 where BNAME='SAP*' and MANDT='xxx'
2> go

 

To check the account status for DDIC

1> select UFLAG from USR02 where BNAME ='DDIC' and MANDT='xxx'
2> go

To unlock the DDIC account

1> update USR02 set UFLAG=0 where BNAME='DDIC' and MANDT='xxx'
2> go

 

MANDT = SAP Client Number
You may add schema owner SAPSR3.USR02 in the query if above query does not work.

 

ABAP system running on MS SQL Server

Using Microsoft SQL Server Management Studio, run the following SQL queries.

To check the account status for SAP*

SELECT UFLAG FROM USR02 WHERE BNAME ="SAP*" and MANDT=xxx

To unlock the SAP* account

UPDATE USR02 SET UFLAG = 0 WHERE BNAME = "SAP*" AND MANDT = xxx

 

To check the account status for DDIC

SELECT UFLAG FROM USR02 WHERE BNAME ="DDIC" and MANDT=xxx

To unlock the DDIC account

UPDATE USR02 SET UFLAG = 0 WHERE BNAME = "DDIC" AND MANDT = xxx

MANDT = SAP Client Number