How do we reset password for SAP* and DDIC user in SAP R/3 4.0B?
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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 administration and NetWeaver administration
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
Learn how to return a list of 1,000 transport requests in SAP R/3 PRD in this tip from SearchSAP.com's Basis expert.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.