Happened to forgot your SAP* pasword in client 000 and you don't know what to do now. You need to log in to client 000 to apply support packages
Create the Program in any other Client and run
it with SAP* User.
It will set the SAP* Password same as in your current client.
* Run this progam as sap* in cient xxx. The user you specify
* as a parameter, will have the same, client xxx password set in every
* where it exists.
TABLES: USR02, T000.
DATA: PASSWD LIKE USR02-BCODE.
PARAMETERS: USER LIKE USR02-BNAME.
SELECT SINGLE * FROM USR02 WHERE BNAME = USER.
IF SY-UNAME <> 'SAP*'.
WRITE: / 'Only SAP* is allowed to run this program'. EXIT.
IF SY-SUBRC <> 0.
WRITE: / USER, 'user does not exist!'. EXIT. "No template user
PASSWD = USR02-BCODE.
WRITE: / 'The password of', USER, 'updated in client:'.
SELECT * FROM T000 WHERE MANDT <> '066' AND MANDT <> SY-MANDT.
SELECT * FROM USR02 CLIENT SPECIFIED WHERE MANDT = T000-MANDT AND
BNAME = USER.
WRITE: / USR02-MANDT.
USR02-BCODE = PASSWD.
USR02-LTIME = SY-UZEIT.
USR02-BCDA1 = USR02-BCDA2 = USR02-BCDA3 = SY-DATUM.
USR02-BCDA4 = USR02-BCDA5 = SY-DATUM.
UPDATE USR02 CLIENT SPECIFIED.
You can logon as DDIC and change the SAP* password
You can also delete SAP* user in client 000. It will default its password to PASS.
SELECT * FROM USR02 WHERE BNAME='SAP*' AND MANDT='000'
Run query to check return. Change Select to Delete
and run again.
Aren't you supposed to use DDIC to install hotpacks?
However, some prefer to use other users besides
How to reset ddic & sap* passowrds on client 000
I install sapr3 4.7 and on WIN 2003& orale Db and after installation
I set the the passwords for SAP* & DDIC on client 000 then I forget
it. Pls help me how to reset them to login to the system by client
000& i in form u i can login with 001 & 066
## Rest the password of 'sap*' in client 000
## Log on to oracle database using sqlplus.
sqlplus / nolog
SQL>connect /as sysdba
SQL>update <SchemaOwner>.USR01 set bname='SAP*1' where bname='SAP*' and MANDT=000;
## [ e.g.: update SAPR3.USR01 set bname='SAP*1' where bname='SAP*'
and MANDT=000; ]
## [e.g. : update SAP<SID>.USR01 set bname='SAP*1' where bname='SAP*' and MANDT=000;]
## This will reset the user SAP* in client 000 . After loggin in client with user SAP* change the passwords for other users.
## You can user client number of your respective client.
## Please note do not reset any other user than SAP* with this method.
Back to Basis Menu:
SAP BC (Basis Components) Hints and Tips
Return to :-
SAP ABAP/4 Programming, Basis Administration, Configuration Hints and Tips
(c) www.gotothings.com All material on this site is
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
All product names are trademarks of their respective companies. The site www.gotothings.com is in no way affiliated with SAP AG.
Any unauthorised copying or mirroring is prohibited.