Alison Balter's Mastering Access 2002 Enterprise Development

Using Views to Secure Data

One of the major benefits of a view is the security that it provides. Consider the following view:

CREATE VIEW vwEmployeeList 
AS 
SELECT EmployeeID, FirstName, LastName, Extension
FROM Employees

This view selects the EmployeeID, FirstName, LastName, and Extension fields from the Employees table. In this scenario, you would grant no rights to certain users for the Employees table. Instead, you would grant them rights to the view. Figure 7.14 shows the Permissions dialog box for a view. Notice that the permissions available for a view are similar to those available for the table. As long as the owner of the table and the owner of the view are the same, the user will be able to interact with the table based on the permissions ...