--- title: "User Control Views" slug: "user-control-views" updated: 2025-03-24T19:18:50Z published: 2025-03-24T19:18:50Z canonical: "skthelp.syniti.com/user-control-views" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # User Control Views > [!NOTE] > Note > > While this functionality is supported in Syniti Construct, SQL access to the list of users is not available. Syniti recommends creating a new table to manually maintain a user list containing the user email addresses. Business rules may require specific functions or fields to be disabled based on the logged in user. Create a *User Control* page to manage the criteria for a User Control View (UCV), such as if records or fields can be added, edited, deleted or even viewed by a specified user. While security groups control edit and delete rights to a page, UCVs control these rights at the *column level*. A single User Control View can control multiple pages in a WebApp if designed correctly and registered to multiple pages. Refer to [Control Views](/v1/docs/control-views) for general information. Setting up a UCV involves the following steps: 1. [Create the User Control View.](/v1/docs/user-control-views#create-the-user-control-view) 2. [Register the User Control View.](/v1/docs/user-control-views#register-the-user-control-view) ## Create the User Control View UCVs are created in SQL Server. Use the following guidelines, which assume basic knowledge of the Syniti Construct methodology and SQL Server, to create a UCV: - Use the naming convention web*Ucv, where * contains the name of the table assigned to the page, minus the prefix. > [!NOTE] > Note > > When controlling multiple pages with a single user control view, [Enforce Strict Naming](/v1/docs/create-a-webapp-in-syniti-construct#naming-conventions-and-the-enforce-strict-naming-feature) on the *WebApps* page in the custom WebApp may need to be disabled 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 column aliases in the view: - **boaUserEmail -** Syniti Construct User Email. The view filters on the current user listed in this column - **boaColumn -** technical name of the column on the page - **boaControlStatus -** control status: disabled (0), enabled (1) and hidden (2) - **boaPageID -** (optional) Syniti Construct Page ID. The view filters on the current page listed in this column > [!NOTE] > Note > > To restrict a specific user's access to update a page, use a UCV to disable Syniti reserved columns, such as - **boaAudit** - **boaAdd** - **boaUpdate** - **boaDelete** ## Register the User Control View To register the UCV to a page: 1. Select **Admin > WebApps** from the *Navigation* pane. 2. Click the **Pages** icon for the desired WEB APP NAME. 3. Click **Vertical View** for the page DESCRIPTION. 4. Click **Control Views** tab. 5. Click **Edit**. 6. Select the SQL view from the **User Control View** list box. 7. Click **Save**. The following optional processes performed in the custom WebApp allow management of the UCV's functionality: - Create a user control *Horizontal* View to manage the criteria. This is a *Horizontal* view that displays data from the user control table. A user control table allows information to be easily configured, rather than hard coding columns to be disable, enabled or hidden in the UCV. Refer to [Guidelines for Horizontal Page Views](/v1/docs/create-views-in-sql#guidelines-for-horizontal-page-views) for more information. - Assign the custom page to the Configuration Menu. Refer to [Add a Menu to the Navigation Pane](/v1/docs/create-a-webapp-in-syniti-construct#add-a-menu-to-the-navigation-pane) for more information. - Create list views for the column properties. Refer to [Add List Boxes and Combo Boxes](/v1/docs/add-list-boxes-and-combo-boxes) for more information.