on 08-13-2014 1:27 PM
Dear consultants,
how to lock the sap users in OS level.please tell me any one.
Hi Pradeep,
you can use tp command to do so:
/usr/sap/<SIS>/SYS/exe/run/tp locksys <SID> pf=<Parameterfile of domain-controler>
after that only sap* and ddic can logon. unlocksys frees the system.
Best regards
Willi Eimler
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pradeep,
The table is usr02. The command is as below:
update <schema>.usr02 set uflag=128;
in case you need to mention any particular user to be locked, mention in the where clause.
Before using this command, use the select statement to check the current status of the users.
Regards,
Meenu Hans
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you are talking about SAP users then they are stored in the database.
You lock the users either from SAP or from the database level by modifying the UFLAG value.
If you are talking about the SAP and DB OS users then follow the standard way of locking the users.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.