How to Lock user in SAP?
Go to SU01
Enter the userID to be locked in the user field and click on lock button Then you will see the the following screen if the user is already locked.
click on the unlock button at the bottom left of the window and the user will be unlocked.to lock a user again enter the user id in the user field and click on lock button and you will see the following screen now press on the lock button to lock the user...you can also lock the user at database level. login to the system database.. then run a query to update the USR02 table.
To lock an user.
SQL> UPDATE USR02 SET UFLAG = '64' where BNAME='USERID' AND MANDT='CLIENT'
SQL> COMMIT
To unlock an user
SQL> UPDATE USR02 SET UFLAG = '0' where BNAME='USERID' AND MANDT='CLIENT'
SQL> COMMIT
Here the different values of uflag have different meaning UFLAG value
0 ------ Not locked
16 ------ Mystery values
32 ------ Locked by CUA admin
64 ------ Locked by system Administrator
128 ------ Locked due to incorrect logon attempts or too many failed attempts
192 ------ A combination of both. The user is locked by admin and user tries to logon with incorrect passwords and gets locked ( 192 = 64+128)
Subscribe to:
Post Comments (Atom)
-
Category : ABAP Programming Error Runtime Errors: READ_REPORT_LINE_TOO_LONG Except.: CX_SY_READ_SRC_LINE_TOO_LONG Detail explanati... -
Function module that will take any internal table as input, convert in to XLS format and send out emails with the attachment. Add the... -
Data Class The data class determines the physical area of the database (tablespace) in which the table is created. You set the data...
No comments:
Post a Comment