How to unlock and reset Sap* and DDIC users

[Former Member]

Hi Experts,

I want to unlock and reset users sap* and DDIC .

Please help me in this regard.

Thanks,

Thirun.

[former_member720526 · Accepted solution]

Is it a dual stack or java only stack? For java stack, you can use the following link

http://help.sap.com/saphelp_nw04/helpdata/EN/3a/4a0640d7b28f5ce10000000a155106/content.htm

If it is a ABAP or dual stack, activate SAP* by checking/changing the parameter login/no_automatic_user_sapstar to 0 at the OS level and restart SAP. You should then be able to login with SAP* and password PASS. If this does not work, you probably have the usermaster for SAP* in which case you can delete the user at the database level.

If the user SAP* is already locked, you have to set the field "UFLAG" in table <SCHEMANAME>.USR02 to "0" for SAP* at the database level.

Hope this helps.

Vipin

[Former Member · Accepted solution]

Thanks Vipin,

Thanks for ur reply.

[former_member238354]

On Database level.

For oracle with typical SAPSR3 schema name

sqlplus / as sysdba<br>update SAPSR3.USR02 set UFLAG='0' where BNAME='DDIC';
commit;
Exit;

SAPGUI comman line (reset ABAP buffer for table)

/$TAB USR02

[Former Member]

Dear Thiru,

To Unlock the user ids:

1. change ur parameter : login/no_automatic_user_sapstar=0

2. using query (DB level) : update <sid>.USR02 set UFLAG = 0 where BNAME = '<user id>'' and mandt = <clinet number>;

also check the link : http://www.sap-img.com/basis/different-methods-to-lock-or-unlock-sap-users.htm

With Regards,

CSK

[Former Member]

Thank you chinnaraj, thanks for ur reply.

[Former Member]

question is how Auditors can trace this activites?