cancel
Showing results for 
Search instead for 
Did you mean: 

SAP* Password And DDIC Password

Former Member
0 Kudos

Dear all,

I m Using windows2003 server, database oracle9i, SAP 4.7 .

i have to configure STMS but my client 000 user SAP* and DDIC password i forget now what is the procedure of login in client 000, i didnt create any other user also so please help me.

thankyou

Raheel

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

The only way is to delete the record of sap* from database level in table usr02 and restart sap.

They you can login with the default password.

Former Member
0 Kudos

Hi,

The only way is to delete the record of sap* and restart sap.

They you can login with the default password.

Former Member
0 Kudos

Hi mohammed raheel,

R u able to login to any other client in the same system ?

If so reset the parameter login/no_automatic_user_sapstar = 1, Take a system restart.

The Sap* password will be reseted to "pass" Default password.

If Help full Reward Points,

with regards,

balaji.s

Former Member
0 Kudos

Dear balaji,

thank you for giving solution .. i solved my problem thank you once again.

i have one more problem just tell me .. i m using windows 2003server Database Oracle9i SAP ECC5 how to create source system for biw.. please tell me procedure ..

warm regards

Raheel

Former Member
0 Kudos

delete SAP* from backend (SQL) and SAP* will be created automatically

Now u can loging through 000 with password PASS

Former Member
0 Kudos

This is the procedure to do it from SQLplus

sqlplus "/as sysdba"

DELETE from SAPR3.USR02 where mandt='000'

and bname = 'SAP*';

Thanks

Bharathwaj V

andreas_herzog
Active Contributor
0 Kudos

> delete SAP* from backend (SQL) and SAP* will be

> created automatically

this definitely is WRONG...if you delete the user SAP* then (of course) all information of the user will be erased...and none of that information will be automatically (magically) re-enabled after deletion...what you mix up is the fact that beside a "regular" sap* user there is always a hard coded sap* which can be used if a regular sap* is not present within the specified client...this hard coded sap* user has the password "pass" (which cannot be changed either as it is hard coded as well!).

GreetZ, AH