background

[Geeth]

hi experts,

Is there a way to unlock a locked user, if the user is locked for more then 10 mins or in case there is a lock on particular table for a long time - do we have any program or a job that can unlock?

[QZ]

Hi Geeth,

USR02-UFLAG determines if a user is locked. I checked online and the values are as follows:

0 Not Locked
32 Locked Globally By Administrator
64 Locked Locally By Administrator
128 Locked Due To Incorrect Logons (Limited Term)

I see a function module named BAPI_USER_UNLOCK. I haven't used it, and there may be
other programs or function modules.

You can get an ABAP developer to write something that unlocks users, and run it every 10 minutes.

From a business standpoint, the auditors (If you are audited) will likely not endorse this idea.


QZ

[Snowy]

Geeth, you are mixing 2 things here:

1, locked users
2. locked tables.

you cannot treat both of them with the same strategy.

what is your real need?

[Geeth]

Sorry let me be clear - In global work process few users are getting stuck on tables, like user ID holding locks on table, so if there are any lock on the table for a long time. I want that to be released.Thanks

[blueteeth]

The problem appears to locks on tables. Please give your RDBMS Version & SAP Version always.

SAP Standard normally do not have locks problem. Check if these locks are occurring due to custom programs. If true, then you may have to sit with your ABAP programmer.

Regards,
BT