Skip to Content
avatar image
Former Member

R/3 Lock/unlock users from SCRIPT

Hello,

We use a script to block users the weekends less those necessary for the business, If I want to see the log of the users in the table ush02 or in the transaction S_BCE_68001439, suim...etc Only shows the information of the users blocked across the transactions EWZ5 and SU10 does not show the information of the users blocked and unblocked by the script, Then the information is not real.

Is not never log in SAP that shows the block and unlocks the users across scripts?

SCRIPT

update usr02 set uflag ='64' where mandt='010' and bname not in <users>

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jan 15, 2008 at 02:05 PM

    The logs in SUIM you refer to are obviously not logs on table changes. They're application logs.

    You could consider to rewrite your script and make it log to the same location the other transactions you mentioned do.

    That way you'll have your information in one place.

    Besides that, maybe there's a 'more sophisticated' way to programmatically lock your users. You might even find a way that does log to the proper location, like a function module........

    There's also an interesting thread in this forum about the values for UFLAG in USR02.

    HTH

    Jurjen

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 15, 2008 at 04:06 PM

    I ran scripts through SECATT and I do have logs.

    Run SECATT select your script->Goto->Logs->search your logs.

    I hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 15, 2008 at 04:19 PM

    I strongly recommend the usage of API functions, such as

    - function module BAPI_USER_LOCK

    - function module BAPI_USER_UNLOCK

    Refrain from updating any DB tables directly !!!

    Add comment
    10|10000 characters needed characters exceeded