Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Sap* and DDIC user login issue

Hello,

I forgot the SAP* and DDIC password in 001 client. I donot have any other user to login into 001 client.

But I can login into 000 client.

How to reset the password in 001 client ?.

Thanks

Thirumal.

Former Member
replied

Dear Thiru,

You got to deletre SAP* from the database

Proceed as follows:

1.Check your instant profile and make login/no_automatic_user_sapstar is set to "0" and now make a restart of your server.

Try this from command prompt.

sqlplus /nolog;

conn /as sysdba;

Now type this and take caution as this is case sensitive:

DELETE FROM <sid>.USR02

WHERE BNAME='SAP*' AND MANDT='<client no.>'

EG-->

DELETE FROM dev.USR02

WHERE BNAME='SAP*' AND MANDT='001'

Then restart your server and login as user SAP* password pass.

Hopefully this will work.

Regards,

Ashutosh

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question