Set a Default User Setting

By | August 11, 2011

Personal Options

Recently came across the request to not allow the users to change one of their personal settings. Through role security you can remove permissions so the user is not allowed to make changes to his/her personal settings. The business required that the users to be allowed change their personal settings though they didn’t want them to be able to change their home page setting.

We had two options to accomplish this: add custom javascript to the out-of-the box page or adding a trigger to the UserSettingsBase table which would put the setting back if the user were to change it. The decision was to go with the less of two evils, adding the trigger.

Options Trigger

The SQL in the trigger is quite simple: the HomePage area column contains the select pane and the HomePageSubAreathe tab.

Download the trigger here.

Leave a Reply