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
