DDIC User can`t log in to the system

[Former Member]

Dears ,

I have ECC 6.0 EHP 4 with OS windows server 2008 R2 and SQL server 2008 R2 , and the DDIC user can`t working in client 000 or in 001.

I need it , because i want to use " SPAM " T-code , in client 001 in spam t-code , give me " Only display function are available " !.

Please can you help me guys ??

Regards.

[Former Member]

Thank you guys for your help .

I`ve use this to solve my issue :

---------

reset the password of sap*

delete from usr02 where mandt='<client>' and bname='SAP*';

after that

login to sap* or DDIC with any client with the password : PASS.

after that you need to create a personal user in " SU01 " then you can use every thing .

--------------

Thanks Everybody 🙂

[Former Member]

DDIC cannot use SPAM and SAINT, you have to create a personal user. And you should do it in client 000.

Cheers Michael

[Former Member]

yes , I have to update it from 000

[pratap_kallam]

Hi Rami,

To unlock user ids:

SQL>update SAP<SID>.usr02 set flag=0 where bname="*user id*" and mandt=client number; SQL>commit; 

To reset the passwords:

SQL>update SAP<SID>.usr02 set bcode="encrypted password" where bname="*user id*" and mandt=client number; SQL>commit;

for yor reference follow the link below

http://scn.sap.com/thread/1367802