SAP Basis users

Where can we find the passwords of users like sap*,DDIC(TCODE?/OS level?)? and How can we change those passwords from os level(windows & Linux)?I know we can change the passwords using the transaction sm01.

rathna
Profile Answers by rathna Questions by rathna
Dec 17th, 2007
4
5428

Questions by rathna

SAP Admin

Answer

Showing Answers 1 - 4 of 4 Answers

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.