Sap* and DDIC user login issue

[Former Member]

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 · Accepted solution]

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

[Former Member · Accepted solution]

Hi Ashutosh,

Thanks for the brief info what i need..

I will try you option and will update..

Thanks.

Thirumal

[Former Member]

no way you can reset password of SAP* and ddic of 001 client fromm 000 client

option avaible with you is to delete sap* of 001 client using sql statements from DB level

Samrat

[Former Member]

HI Samrat,

Thank you,

I also red some forums said to delete at DB level using below query

"delete from usr02 where mandt=<your login client> and banme='SAP*';

But i couldnot find the USR02 table.

Couly you give me the Correct query ?.

Thank

Thirumal

[TomCenens]

>

> no way you can reset password of SAP* and ddic of 001 client fromm 000 client 
> option avaible with you is to delete sap* of 001 client using sql statements from DB level
> 
> Samrat

Not entirely true you can update a few fields in table usr02 for sap* and/or ddic so they have the same password in client 001 as in client 000 that way you do not need a restart either

[TomCenens]

You need to put the database schema in front

SAPSR3DB.USR02 for example

delete from sapsr3db.usr02 where mandt='000' and bname='SAP*';

commit;

[Former Member]

Hi Ashutosh/Tom,

Thank you very much for your brief information abt the issue. Its really helped me to fix the issue very shortly... ..

Now i am anble to login into the Client 001 ..

Thanks

Thirumal.