Business rules may require specific functions to be disabled based on the logged in user. A User Control page can be created to manage the criteria for a User Control View. UserControl Views (UCV) are created in SQL and determine if records can be added, edited, deleted or even viewed by a specified user. Once the views are created in SQL, they need to be registered to the page in DSP® and the control criteria must be defined. A single User Control View can control multiple pages in a WebApp if designed correctly and registered to multiple pages.
Refer to Control Views for general information.
When creating User Control Views (UCV):
- Use the naming convention webXXXUcv, where XXX is the name of the table assigned to the page minus the prefix.
- If using one UCV across multiple tables, XXX is a meaningful name.
NOTE: When controlling multiple pages with a single User Control View, Enforce Strict Naming might need to be turned off depending on the naming convention on the view.
- Use a UCV when the control status determinations are to be made based on what is known about the User.
- Include the following columns:
- boaUserID – Contains DSP® User ID
- boaColumn – Technical name of column on the page
- boaControlStatus – Control Status: disabled (0), enabled (1) and hidden (2)
NOTE: Besides the DSP® Reserved Words, no other columns are considered when applying the UCV control status settings to a page.
Setting up user control views involves the following steps:
- Create a User Control View in Management Studio.
- Register the view in DSP®.
- Define the control criteria on the new page.
The following steps are optional to allow management of the control view’s functionality:
- Create a User Control table.
- Create a User Control Horizontal View to manage the criteria.
- Register the Page in DSP® and assign to the Configuration Menu.
- Create list views for the Column Properties.
- Assign Column Properties.