Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Copper Contributor
Posts: 18
Registered: ‎12-08-2009

New users has no records associated in user options table?

Surely I'm not the first to realize that once you create a new user in a SalesLogix Web based environment (7.5.x, 8.0.x, 8.1.x), the user option table has not been populated with the userid.


In order to populate it, you should log on into SLX Web Client with the user, change something at User Option Level, save and Voilà!


So, if you don't use remote users, a workaround to solve it is creating a DB Trigger (After Insert on UserInfo). In that way, anytime you create a user, the trigger will insert records into useroptions table, based on the "User Info template" defined within the trigger. 


Although it seems that the problem was solved, I have many unanswered questions:


  1. If there is not records on the user options table, where is that information coming from?
  2. Is there anyway to apply a massive user options configuration for all users?; and finally
  3. There must be a better solution, not just a workaround!!!