Keeping track of SAP* and DDIC Userid’s and Passwords
Obviously, it is important to keep track of all the userid’s and passwords to your SAP systems since there is no one besides you, the BASIS Administrator, that will know this information.
However, there are times when this information is changed but not written down and forgotten and you end up locked out of your system. What are you going to do then?
Solution to the problem
If you no longer know the passwords for SAP* and DDIC or any other user with permissions to reset a password in SU01, then you will have follow these steps in order to resolve this problem.
Step by Step Process
1. Log onto the database using the database utilities.
start sqlplus connect sapr3/sap
2. Delete the SAP* user account with the following SQL statement.
delete from usr02 where mandt='' and bname='SAP*';
3. Log on to the system with userid SAP* and the password ‘PASS’.
4. Check the profile parameter: login/no_automatic_user_sapstar=1, it will deactivate the sap*! Simply change its value from 1 to 0 and it will work.
5. Be sure to re-boot the system
6. Make sure that you reset the password for userid DDIC also.