topic change DDIC password in Application Development and Automation Discussions

change DDIC password

Former Member — Fri, 15 Jun 2007 06:30:19 GMT

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.

Re: change DDIC password

Former Member — Fri, 15 Jun 2007 06:38:30 GMT

Hi lee,

Try to reset the password from Oracle database:

Logon to your database with orasid as user id and run this sql

delete from sapSID.usr02 where bname='DDIC' and mandt='XXX';

commit;

Where mandt is the client.

Hope it helps.

Please award points if it is useful.

Thanks & Regards,

Santosh

Re: change DDIC password

Former Member — Fri, 15 Jun 2007 06:50:07 GMT

hi santhosh,

once reset which password ddic will get.

am using IDES ecc6 with MS SQL.

Re: change DDIC password

Former Member — Fri, 15 Jun 2007 06:58:19 GMT

Why bother one should not logon with DDIC, as it is mutch to powerfull to use!

Re: change DDIC password

Former Member — Fri, 15 Jun 2007 07:09:24 GMT

Hi,

Use 'PASS'

Thanks & Regards

Santosh

Re: change DDIC password

Former Member — Fri, 15 Jun 2007 07:45:52 GMT

HI SANTHOSH,

am using MS SQL 2005.

Thanks for ur update

Re: change DDIC password

Former Member — Fri, 15 Jun 2007 08:22:51 GMT

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.

Re: change DDIC password

Former Member — Fri, 15 Jun 2007 08:42:19 GMT

Hi Lee,

Do This logon user sap* or any user who have SAP_ALL access and change DDIC password via T Code SU01.

Reward point if helpful

Thanks

Pankaj Kumar

Re: change DDIC password

Former Member — Thu, 21 Jun 2007 13:17:30 GMT

hi,

am using SQL

what DB name i want to use while running that script

--- Lee

Re: change DDIC password

Former Member — Thu, 21 Jun 2007 13:42:27 GMT

ddic and sap* both locked in 000 in ECC 6

DB MS SQL 2005

how to reset the ddic password.

detail pls ....

Re: change DDIC password

Former Member — Fri, 22 Jun 2007 07:39:08 GMT

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

Re: change DDIC password

Wolfgang_Janzen — Mon, 02 Jul 2007 12:51:12 GMT

@Raju: that information is wrong.

There is only one emergency user account (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 after 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