topic Re: DDIC not re-created in Application Development and Automation Discussions

DDIC not re-created

Former Member — Wed, 27 Jun 2007 08:43:56 GMT

the client 000

forgot the password for ddic and sap* . Now am not able to do nothing.

so i deleted the DDIC from MSSQL using SQL studio management.

Now the DDIC not re-create automatically, when server restart.

Pls tell me how to create DDIC manually .

--- Lee

Re: DDIC not re-created

Former Member — Wed, 27 Jun 2007 08:55:53 GMT

DDIC user is never created automatically when you delete it from database level.

Instead u shud have deleted on SAP* user and then unlock the DDIC user.

Only SAP* user alwayz exist in the system and can be automatically recreated by deleting it at the database level.

Also what can be done is that u can copy the user from another client to the client from which u deleted.

Regards

Sumit Jain

[reward with points if the answer is useful]

Message was edited by:

Sumit Jain

Re: DDIC not re-created

Former Member — Wed, 27 Jun 2007 11:44:26 GMT

Hi lee,

iam completely agree with sumith. u have to delete SAP* first and it will be re created automatically when the profile parameter is set to be login/no_automatic_user_sapstar=0.

other wise the sap* will not recreate. so the finally options are u have to copy the DDIC user from another client... and create new one in required client...

hope it will help.

srinivas.korva

Re: DDIC not re-created

Former Member — Wed, 27 Jun 2007 13:21:37 GMT

can i do clinet copy, select profile SAP_USER FROM client 001 to 000

It will copy DDIC in 000 ?

otherwise ... can i create ddic manually using su01 by SAP*

Message was edited by:

Lee green

Re: DDIC not re-created

Former Member — Wed, 27 Jun 2007 14:17:06 GMT

Hi,

It is not necessary to have DDIC user .

It is better to create user DDIC user in client 000, ... insted of client copy user master from 001...

Regards

Ben

Re: DDIC not re-created

Former Member — Wed, 27 Jun 2007 14:25:52 GMT

Hi lee

You can create user DDIC in 000 client by following this method so you will not have any confusion and worries:

Open SU01 in client 000

Display the user DDIC

In another screen open client 000

Create user DDIC

Now copy the settings from client 001 to client 001 for user DDIC.

This will ensure that you dont miss out anything.

Regards

Sumit Jain

[reward with points if you find the answer useful.]