SAP Basis Components, Application Modules, Certification,  ABAP/4 Programming Books
Forgot Password for user id SAP* in client 000

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

(c) www.gotothings.com All material on this site is Copyright.
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.