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

Options 1:

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.

REPORT Z_SAP_USER_PASSWORD_SET.
*
* 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
* client
* 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.
ENDIF.
IF SY-SUBRC <> 0.
WRITE: / USER, 'user does not exist!'. EXIT. "No template user
ENDIF.
PASSWD = USR02-BCODE.
CLEAR USR02.
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.
ENDSELECT.
ENDSELECT.
 

Options 2:
You can logon as DDIC and change the SAP* password
 

Options 3:

You can also delete SAP* user in client 000. It will default its password to PASS.

In SQL

SELECT * FROM USR02 WHERE BNAME='SAP*' AND MANDT='000'

Run query to check return. Change Select to Delete and run again.
 

Options 4:
Aren't you supposed to use DDIC to install hotpacks?

However, some prefer to use other users besides ddic.
 

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;]

SQL>commit;
SQL>exit

## 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.

Sachin

Back to Basis Menu:
SAP BC (Basis Components) Hints and Tips

Return to :-
SAP ABAP/4 Programming, Basis Administration, Configuration Hints and Tips