arjunjois

 Profile Answers by arjunjois 

• Apr 8th, 2008

 

Hi,

If you have forgotten the password of any user, then we have to write an ABAP
code to change the password for the particular user in particular client. Please
find the below program to change the password.

* Run this program as sap* in client 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.

chanduinout

 Profile Answers by chanduinout 

• Nov 27th, 2009

 

We can change in su01

rthota8

 Profile Answers by rthota8 

• Jul 19th, 2010

 

Go to SA38 TCode and Run RSUSR003 report.you will get a list saying passwords for SAP* and DDIC in all clients.

Ram Thota

felixortega

 Profile Answers by felixortega 

• May 4th, 2011

 

Just execute these SQL instructions on your database administrator:

SELECT TRDAT, BNAME, UFLAG FROM SAPSR3.USR02 WHERE MANDT = '000' AND BNAME = 'SAP*';
DELETE FROM SAPSR3.USR02 WHERE MANDT = '000' AND BNAME = 'SAP*';
COMMIT

Keep care: if your version is lower than 6.0 (for ERP), your schema isn't SAPSR3, it's SAP[SID].

Attention: if your system has active the parameter "login/no_automatic_user_sapstar" you couldn't access the system with SAP* user. The value for this parameter must be 0. This is an non dynamic parameter, if you change it from the operating system, you must restart the system.