Forgot password of ddic and SAP * user

[Former Member]

Hi

I forgot password of user sap* and DDIC

i change the password after copy client

How can I login in that client

And how to delete that client with out login in that client

help me out asap

[Former Member · Accepted solution]

try running this script on your database:

DELETE FROM <sid>.USR02

WHERE BNAME='DDIC' AND MANDT='<client no.>'

On the script above, <sid> is the system ID. So let say my system ID is "fld" and client is "100", my script would be:

DELETE FROM fld.USR02

WHERE BNAME='DDIC' AND MANDT='100'

After you run the script successfully, you can now log on that client using DDIC and password = pass

[Former Member · Accepted solution]

Script is not working

[Former Member · Accepted solution]

1. Open SQL server management studio

2. Login

3. Expand the database node

4. Click your specific database and click "New Query"

Then use the script I posted earlier. Take note that this is case sensitive so make sure that all table names and field names are in uppercase.

[Former Member · Accepted solution]

Hello Dear richard santos. Are you check this script for you? Are you thing the default password for DDIC are PASS ? Why you think so? As i know the DDIC user are present in 001 and 000 client and default password are the 19920706. Try to read the http://help.sap.com/saphelp_nw70/helpdata/EN/3e/cdaccbedc411d3a6510000e835363f/frameset.htm.

For this problem you need to activate the emergency SAP* user , not DDIC. For this you need to check the login/no_automatic_user_sapstar are set to 0,and delete the SAP* from user master record. After restart the AS ABAP, you can able the login with SAP* and password PASS.

http://help.sap.com/saphelp_nw70/helpdata/EN/52/671792439b11d1896f0000e8322d00/frameset.htm

Regards.

[Former Member · Accepted solution]

Hello,

Yes sergo you are correct. Thanks for that correction and sorry for the wrong info. So jayesh here's your new script.

DELETE FROM <sid>.USR02

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

Regards,

Richard

[Former Member · Accepted solution]

Thanks Santos

My problem is solved now

thank for help full information

full point to from help me

[former_member276340 · Accepted solution]

Thank you, this post is very usefull, always returning here %)

[Former Member]

Hi this is ramana i am not able to open sap*  with password "pass" client 000 pls give me the reply..

[Former Member]

This message was moderated.

[Former Member]

hello

DELETE FROM <sid>.USR02

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

or else login/no_automatic_sapstar set value 0..........

thanks

viswanadharaju

Message was edited by: viswanadharaju sagi

[Former Member]

Hi there,

Sqlplus "/as sysdba"

delete from sapr3.usr02 where bname='SAP*' and mandt='<Client number>';

Login with SAP* (with password 'pass') in the client. You can now reset password for ddic.

You can delete the client by Tcode SCC5.

Regards,

Pranay.

[Former Member]

Data base Is SQL 2005