Unlock & Reset SAP* Password in MaxDB

via MaxDB SQL Studio

Login to your operating system. Open your MaxDB SQL Studio. Open the SQL dialog.

Check status

select * FROM USR02 where BNAME='SAP*' and MANDT='client'

Unlock

update USR02 set UFLAG=0 where BNAME='SAP*' and MANDT='client'

Delete/Reset current password

delete FROM USR02 where BNAME='SAP*' and MANDT='client'

via SQLCLI

Login to your SQLCLI as SAPSID. Open the SQLCLI and connect to the database as

sqlcli> \c -d SID -u SAPSID,PASSWORD
connected to SID

Check status

select * FROM SAPSID.USR02 where BNAME='SAP*' and MANDT='client'

Unlock

update SAPSID.USR02 set UFLAG=0 where BNAME='SAP*' and MANDT='client'

Delete/Reset current password

delete FROM SAPSID.USR02 where BNAME='SAP*' and MANDT='client'

Note

• Default password for sap* is pass / 06071992.
• Execute transaction code /$tab to reset buffer