change DDIC password

[Former Member]

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.

[Former Member]

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

[Former Member]

hi santhosh,

once reset which password ddic will get.

am using IDES ecc6 with MS SQL.

[Former Member]

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

[Former Member]

Hi,

Use 'PASS'

Thanks & Regards

Santosh

[Former Member]

HI SANTHOSH,

am using MS SQL 2005.

Thanks for ur update

[Former Member]

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.

[Former Member]

hi,

am using SQL

what DB name i want to use while running that script

--- Lee

[Former Member]

ddic and sap* both locked in 000 in ECC 6

DB MS SQL 2005

how to reset the ddic password.

detail pls ....

[Former Member]

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

[WolfgangJanzen]

@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

[former_member190272]

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