How to turn off the user log in timeout option for all users in the SalesLogix web client

In the SalesLogix web client each user has to specify if they want to be automatically logged off after a period of inactivity.  I was recently asked if there was a way of setting this to be off for all users.  The answer is yes.  These settings are all stored in the UserOptions table.  It is possible that the settings do not exist yet for users as they are only created the first time they make changes, but here is the SQL statements you owuld need to run to either update or create the parameters to not log off after a period of time.  (There are three records involved in the timeout area):

update USEROPTIONS set OPTIONVALUE=’False’ where CATEGORY=’GENERAL’ and NAME=’USEAUTOLOGOFF’ and Cast(isnull(OPTIONVALUE,”) as varchar(50))<>’False’

insert into USEROPTIONS
(OPTIONID, CREATEUSER, CREATEDATE, MODIFYUSER, MODIFYDATE, USERID, LOCKED, OPTIONVALUE, CATEGORY, NAME)
select
‘FX1’ + right(a.userid,9) OPTIONID, 
‘ADMIN’ CREATEUSER,
getutcdate() CREATEDATE,
‘ADMIN’ MODIFYUSER,
getutcdate() MODIFYDATE,
a.userid USERID,
‘F’ LOCKED,
‘False’ OPTIONVALUE,
‘GENERAL’ CATEGORY,
‘USEAUTOLOGOFF’ NAME
from userinfo a left join USEROPTIONS b on a.userid=b.userid and b.NAME = ‘USEAUTOLOGOFF’ left join
usersecurity c on a.userid=c.userid
where b.userid is null and c.type not in (‘T’,’R’)

insert into USEROPTIONS
(OPTIONID, CREATEUSER, CREATEDATE, MODIFYUSER, MODIFYDATE, USERID, LOCKED, OPTIONVALUE, CATEGORY, NAME)
select
‘FX2’ + right(a.userid,9) OPTIONID, 
‘ADMIN’ CREATEUSER,
getutcdate() CREATEDATE,
‘ADMIN’ MODIFYUSER,
getutcdate() MODIFYDATE,
a.userid USERID,
‘F’ LOCKED,
’30’ OPTIONVALUE,
‘GENERAL’ CATEGORY,
‘LOGOFFDURATION’ NAME
from userinfo a left join USEROPTIONS b on a.userid=b.userid and b.NAME = ‘LOGOFFDURATION’ left join
usersecurity c on a.userid=c.userid
where b.userid is null and c.type not in (‘T’,’R’)

insert into USEROPTIONS
(OPTIONID, CREATEUSER, CREATEDATE, MODIFYUSER, MODIFYDATE, USERID, LOCKED, OPTIONVALUE, CATEGORY, NAME)
select
‘FX3’ + right(a.userid,9) OPTIONID, 
‘ADMIN’ CREATEUSER,
getutcdate() CREATEDATE,
‘ADMIN’ MODIFYUSER,
getutcdate() MODIFYDATE,
a.userid USERID,
‘F’ LOCKED,
‘Minute(s)’ OPTIONVALUE,
‘GENERAL’ CATEGORY,
‘LOGOFFUNITS’ NAME
from userinfo a left join USEROPTIONS b on a.userid=b.userid and b.NAME = ‘LOGOFFUNITS’ left join
usersecurity c on a.userid=c.userid
where b.userid is null and c.type not in (‘T’,’R’)

ABOUT THE AUTHOR

Kris Halsrud

Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) news and product updates!

You have Successfully Subscribed!