The Source Code - Multilevel Security for Relational Databases - page 179

GO
CREATE VIEW [dbo].[vwEmployee]
AS
SELECT dbo.GetColumnData(dbo.Employee.Name, dbo.
Employee.CName) AS Name, dbo.GetColumnLabel
(dbo.Employee.CName) AS ClassName,
dbo.GetColumnData(dbo.Employee.Department,
dbo.Employee.CDept) AS Department, dbo.
GetColumnLabel(dbo.Employee.CDept) AS ClassDept,
dbo .GetColumnData(dbo.Employee.Salary,
dbo.Employee.CSalary) AS Salary, dbo.
GetColumnLabel(dbo.Employee.CSalary) AS
ClassSalary,
dbo.GetColumnLabel(dbo.Employee.TC) AS TC
FROM dbo.Employee INNER JOIN
dbo.vwVisibleLabels ON dbo.Employee.TC
= dbo.vwVisibleLabels.ID
GO
CREATE VIEW [dbo].[VBCEmployee]
AS
SELECT Name, dbo.GetBCUserView(CName) AS C _ Name,
Department, dbo.GetBCUserView(CDept) AS C _ Department,
Salary, dbo.GetBCUserView(CSalary) AS C _ Salary,
dbo.GetBCUserView(TC) AS C_Tuple
FROM dbo.BCEmployee
WHERE (dbo.GetBCUserView(TC) <> '')
GO
CREATE VIEW [dbo].[UserVisibleSmithEmployee]
AS
SELECT dbo.SmithEmployee.name, dbo.SmithEmployee.
CName, dbo.SmithEmployee.Department, dbo.
SmithEmployee.Salary, dbo.SmithEmployee.TC
FROM dbo.SmithEmployee INNER JOIN
dbo.vwVisibleLabels ON dbo.GetLabelID
(dbo.SmithEmployee.TC) = dbo.
vwVisibleLabels.ID
GO
CREATE VIEW [dbo].[UserVisibleSeaViewEmployee]
AS
SELECT dbo.SeaViewEmployee.name, dbo.SeaViewEmployee.
CName, dbo.SeaViewEmployee.Department, dbo.
SeaViewEmployee.CDept, dbo.SeaViewEmployee.Salary,
dbo .SeaViewEmployee.CSalary, dbo.
SeaViewEmployee.TC
FROM dbo.SeaViewEmployee INNER JOIN