--- title: "Create a View" slug: "create-a-view" updated: 2024-03-14T07:45:51Z published: 2024-03-14T07:45:51Z canonical: "skthelp.syniti.com/create-a-view" --- > ## 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. # Create a View > [!NOTE] > Note > > This section only applies to custom components. Create a view in a database on the Syniti Construct database instance that returns the values that represent the data items by which security can be defined. The view must follow the name convention: **web*Sec**. These views should return all of the columns that are going to be applicable in the security model. The following view is an example of how to build a view to restrict access on the Customers page to specific CustomerIDs: CREATEVIEW [dbo].[webCustomerIDSec] AS SELECT CustomerID FROM dbo.Customers It is important to note here that 1 -> n columns can be defined in the Sec view, where *n* is the number of columns being used in defining security. For this example, a second security view will be created that grants record visibility based on ContactTitle and City: CREATEVIEW [dbo].[webContactTitleCitySec] AS SELECTDISTINCT ContactTitle, City FROM dbo.Customers In addition to the columns that will be explicitly used in defining security, designers can also include a column aliased as “FriendlyName,” and the value returned in this column will be displayed to the on-site administrators when they are deciding which values to assign to a role or a user. The following is an example of security view with “FriendlyName”: CREATEVIEW [dbo].[webCustomerIDFriendlyNameSec] AS SELECT CustomerID, CompanyName AS FriendlyName FROM dbo.Customers