on 10-13-2009 4:47 PM
hi guys,
i want to reconfigure my TMS on DEV but we cant remember the passwords of sap* and ddic.
wat do u suggest i do?
Regards Walata
Hi,
You can reset password of SAP* as follows:
To reset SAP* password, please follow this step:
1. Set the profile parameter login/no_automatic_user_sapstar to 0 from RZ10 (If you canu2019t logon, you can edit your Instance Profile directly from the OS level, folder /usr/sap/<SID>/SYS/profile, )
2. Restart Application Server.
3. Logon to your SQL command (eq: SQL PLUS for Oracle) and connect as SYSDBA.
4. Run: SELECT * FROM [DBSID].USR02 WHERE BNAME=u2019SAP*u2019 AND MANDT=u2019<client>u2019
Example: SELECT * FROM PRD.USR02 WHERE BNAME=u2019SAP*u2019 AND MANDT=u2019000'
5. If exist, then run:
DELETE FROM PRD.USR02 WHERE BNAME=u2019SAP*u2019 AND MANDT=u2019000'
Make sure the user deleted by re-run step 4.
6. Logon to Client with user SAP* and password: pass
Thanks
Sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.