How do we reset password for SAP* and DDIC user in SAP R/3 4.0B?
If you cannot log in as SAP*, you can carefully delete it at the database level.
Issue a delete statement against table USR02, which is the one that keeps the passwords.
Example: delete USR02 where BNAME = 'SAP*' and MANDT='100'
Make sure you delete it only in the desired client.
After this, you will be able to log on as SAP* again with password PASS.
Then, you can change the DDIC password and go from there.
Dig Deeper on SAP Basis
Related Q&A from Giovanni Davila
Learn how to transfer a client from one server to another in this administration tip from Basis guru Giovanni Davila. Continue Reading
Learn fundamentals of transport management and STMS from Basis guru Giovanni Davila in this expert tip. Continue Reading
Giovanni Davila, Basis expert, provides advice on how to copy all SAP users from one system to another in this tip. Continue Reading