When you are Locking/Unlocking accounts what happens behind the scenes?
User accounts can be locked/unlocked via SU01 (User Maintenance.) But, what goes on behind the scenes? What does the system do to actually set this?
The table USR02 gets updated. The field UFLAG determines if the user account is locked or unlocked. The value "64" indicates that the user account is locked. The value "0" that the user account is unlocked. Knowing this, you can then issue an update statement at the database level that locks all users in mass.
Don't lock yourself out, though! Use exceptions for super user accounts in your update statement.Notice that 4.6b and above have made improvements to this kind of task, making the locking/unlocking a bit easier. However, changing at the database level is much faster and it is just one simple query.
Confused? Feel free to ask
Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk
0 comments:
Post a Comment