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
