How infor syteline quickly locks users

When using the infor syteline ERP system, when system maintenance is required, we need to notify all users to exit the system. During the maintenance period, user login is prohibited. In this case, we need to lock the user.
For this problem, many administrators will openUsersWindow, switchLogin informationLabelUser Login statusIs changed to disabled.

 

After system maintenance is completed, change it back. This method can only be applied to a small number of users. If multiple users in your system need to be locked, it will be a pain. Is there a faster way? Yes.

You can calibrate the mouse light in this field, and then go to the toolbarEditUnderReplace value in Collection:

 

Replace active with disabled:

This can be performed in batches. After the maintenance is complete, repeat these steps and replace them.

The above methods can achieve the locking effect. But the insus. Net method does not. It is performed in the database query analyzer.

The following SQL statement can be used to view users:

SELECT * FROM [XXX_App].[dbo].[UserNames]

View code

The above [xxx_app] is the name of your SL application database. The following shows the same understanding.

The following SQL statement is used to view all users currently logged on and using SL:

SELECT * FROM [XXX_App].[dbo].[ConnectionInformation]

View code

OK. Now we can use the following SQL to lock the user. For details, refer:

 

Use SQLUsernamesTableStatusField updates.UseridTo exclude 1 and 2. That is the system account.
When maintenance is complete and the system is re-opened to usersStatusUpdate to 0.

How infor syteline quickly locks users