System Administration
NOTE: This section only applies to custom components. Create a view in a database on the Stewardship Tier 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
