no access to sap* and ddic passwords

[Former Member]

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

[sunny_pahuja2]

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

[Former Member]

4. Run: SELECT * FROM DBSID.USR02 WHERE BNAME=u2019SAP*u2019 AND MANDT=u2019<client>u2019

You have to use schema id instead of DBSID. e.g. SAPSR3

@Sunny, hope this is ok.

[sunny_pahuja2]

Hi Manoj,

that's fine..thanks for correcting me...

Thanks

Sunny