unlock the users sap* and ddic

[Former Member]

Hi,

i have installed ecc 6.0, i have tried to login with diffrent passwords with sap* and ddic in 000 client.

both users are locked. now i am unable to login with 000 client.

please tell me the procedure to unlock users sap* and ddic

Thanks

Prabhakar

[Former Member · Accepted solution]

Hi,

Welcome to SDN!!!

I request you to search in the sdn there are many post on this topic.

Regards,

Vamshi.

[Former Member]

Hi Prabhakar,

As you are not mentioned your Database, I am assuming as oracle and providing the commands at database level to unlock the users:

login to SQL:

_Unlocking SAP:_*

1.select mandt,bname from SAP<SCHEMAID>.USR02 where mandt=000 and bname ='SAP*';(just for checking)

->delete from SAP<SCHEMAID>.USR02 where mandt=000 and bname='SAP'; ( it will unlock the sap)

-> commit;

Unlocking DDIC:

2. select mandt,bname from SAP<SCHEMAID>.USR02 where mandt=000 and bname ='DDIC';

-> ->delete from SAP<SCHEMAID>.USR02 where mandt=000 and bname='DDIC*'; ( it will unlock the DDIC)

-> commit;

After this try to login with SAP* and DDIC with the passwords which you are given during the installation, if you get the result as name/password is incorrect then you user pass for SAP* and 19920706 for DDIC( only in case if you get error).

Hope this will resolves your issue.

Thanks

Kishore

[Former Member]

Hi,

You need to do it at the Database level.

Rgds,

Suman

[karthic_rajganesan]

You can reset the password at Database level.. USR02 is the table...