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
Giovanni Davila, Basis expert, provides advice on how to copy all SAP users from one system to another in this tip. Continue Reading
Describes how to run transaction SU01 to verify if CUA is used on an SAP system. Continue Reading