06-15-2007 7:30 AM
hi ,
i forgot 000 client ddic password.
but i know 001 client ddic password.
how to reset the 000 ddic password ?
am using IDES EEC 6.
06-15-2007 7:38 AM
Hi lee,
Try to reset the password from Oracle database:
Logon to your database with orasid as user id and run this sql
<b>delete from sapSID.usr02 where bname='DDIC' and mandt='XXX';
commit;</b>
Where mandt is the client.
Hope it helps.
Please award points if it is useful.
Thanks & Regards,
Santosh
06-15-2007 7:38 AM
Hi lee,
Try to reset the password from Oracle database:
Logon to your database with orasid as user id and run this sql
<b>delete from sapSID.usr02 where bname='DDIC' and mandt='XXX';
commit;</b>
Where mandt is the client.
Hope it helps.
Please award points if it is useful.
Thanks & Regards,
Santosh
06-15-2007 7:50 AM
hi santhosh,
once reset which password ddic will get.
am using IDES ecc6 with MS SQL.
06-15-2007 7:58 AM
Why bother one should not logon with DDIC, as it is mutch to powerfull to use!
06-15-2007 8:09 AM
06-15-2007 8:45 AM
06-15-2007 9:22 AM
Hello Lee,
You can reset the DDIC password with any User having admin privileges for example you can reset using SAP* user (login using SAP* user , goto SU01 and reset the DDIC user password) , if you dont have any user to reset the password then run the SQL query
DELETE from sap<SID>.usr02 where BNAME='DDIC' and MANDT='XXX';
COMMIT;
now DDIC user can login into this client with password 'PASS'.
Regards,
Raju.
06-21-2007 2:17 PM
hi,
am using SQL
what DB name i want to use while running that script
--- Lee
06-21-2007 2:42 PM
ddic and sap* both locked in 000 in ECC 6
DB MS SQL 2005
how to reset the ddic password.
detail pls ....
06-22-2007 8:39 AM
I HAD deleted the DDIC
i TRIED the password " PASS " " 19920706"
but nothing will solve my problem
ddic and sap* not working
pls .....help me
07-02-2007 1:51 PM
@Raju: that information is wrong.
There is <b>only one emergency user account</b> (per client, and there is no need for more than one to exist) - and that's the one described in <a href="https://service.sap.com/sap/support/notes/2383">SAP Note 2383</a>.
DDIC is an "ordinary" user (regarding authentication). If you have to reset his password you need to logon with another user (e.g. the emergency user) which is empored to set a new password for user DDIC.
When trying to activate the emergency user SAP* kindly notice that you might have to set profile parameter login/no_automatic_user_sapstar = 0 (see <a href="https://service.sap.com/sap/support/notes/68048">SAP Note 68048</a>) and that you have to restart the application server <u>after</u> deleting the DB record (using some native SQL tools) since the ABAP application server is buffering the content of table USR02 (as of release 6.10).
Regards, Wolfgang
06-15-2007 9:42 AM
Hi Lee,
Do This logon user <b>sap*</b> or any user who have <b>SAP_ALL</b> access and <b>change DDIC</b> password via T Code <b>SU01</b>.
Reward point if helpful
Thanks
Pankaj Kumar