reset user password through command line

[sheshman]

Hello,

My SAP server works on windows and using S4/Hana DB and I'm trying to reset user's password through command line.

I've found that it is possible by using R3trans command and prepared password_reset.txt file as below;

export
client=400
user=username
password=123456

and run this command;

R3trans -w password_reset.log password_reset.txt

but it gives me this output

4 ETW000 R3trans version 6.26 (release 777 - 19.06.24 - 15:07:06).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000 
4 ETW000 date&time   : 06.12.2024 - 13:31:45
4 ETW000 control file: password_reset.txt
4 ETW000 > export
4 ETW000 > client=400
4 ETW000 > user=SONERCTEST
4 ETW000 > password=123456
4 ETW000 R3trans was called as follows: R3trans -w password_reset.log password_reset.txt
3WETW000 obsolete R3trans option ignored: USER=SONERCTEST (line 3).
4 ETW000 
2EETW000 error when reading the R3trans controlfile
2EETW000 unknown option PASSWORD = yes at line 4, symbol "=".
2EETW000 error when reading the R3trans controlfile
2EETW000 syntax error at line 4, symbol "123456".

What am i doing wrong here?

[prithvirajr]

Hi Sheshman,

In my opinion, R3trans does not support this functionality, I may be wrong.

And even if it is possible, when there are many other reliable and secure ways to achieve this, why go with R3trans? There are DB-specific tools, and SAP applications (frontend) to do what you want to do.

Regards,

Prithviraj

[sheshman]

In our system more than 400 users and most of them are keep forgetting or locking their users, half of my day spending to onluck or reset their passwords, i thought that if i can prepare an automation it'll be much more easier to reset their password by sending their username to that automation instead of goto solman and su01 reset & unlock 🙂 Can you suggest some of that other ways so i can work on?

[prithvirajr]

There are multiple ways you can achieve this, some of them are

[sheshman]

is there any chance that you forgot to type alternatives in your comment? all i see is "There are multiple ways you can achieve this, some of them are"

[prithvirajr]

There are multiple ways you can achieve this, some of them are. 1. User GRC self service process which will automate the password reset issue. https://community.sap.com/t5/financial-management-blogs-by-members/password-self-service-amp-end-use... 2. Activate login/failed_user_auto_unlock this parameter will unlock the users every midnight. The catch is it will only unlock the users that are locked by login failure attempts, and not by administrator. 3. You can create a ABAP program to unlock the users and generate the report of it. 4. If GUI scripting is allowed at your end, then check the blog https://community.sap.com/t5/application-development-blog-posts/sap-gui-script-recording-amp-playbac... If you ask me the option 1 is the best given the security and compliance risk and issues that we face regularly.