SAP BASIS INTERVIEW QUESTIONS

_____________________________________________

Question 24:

Locking Accounts

When you are Locking/Unlocking accounts what

happens behind the scenes?

A: 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.

- 34 -