Views

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Access Workflow Designer uses views to access each database table. SQL views are similar to a virtual table or a stored query and server as a consistent, SQL-based interface to data. Views control the access to data in user tables using access permissions on views and row-level permissions. Views for detail tables handle column and table permissions for their table. For row-level security, the detail view looks up the hierarchy chain and enforces permissions as defined in the main table.

Tables that do not require views initially can add a lookup or permissions table and, therefore, may eventually require a view. It is recommended you design your database to meet future requirements and use views of your data.

The views created by Access Workflow Designer have the same schema as their underlying tables, with synonym columns. The views are registered in the modObjects table and have the table ID as the parent ID.

Tables in a solution hierarchy are treated, for most purposes, as independent tables. Views are created for each main and detail table. Those views are the building blocks for data hierarchies. Views do not span over more than one data table, however (for example, a flat recordset that includes a column from two or more user tables).

What Does a View Do?

  • Enforces table-level permissions. By default, tables are not accessible to solution users. Object-level permissions are set on the view.

  • Resolves row-level permissions, including permissions for detail tables in a hierarchy.

  • Makes it possible for updates to the underlying user table.

For more information about SQL Views, see the SQL Server Books Online.

Access Workflow Designer System Views

When creating a team solution, the Access Workflow Designer extends your solution database by creating a number of system views. These views exist in the solution database and provide developers with controlled access to data in the modSystem database. Two views are associated with user tables.

View Description
modUserList Filters the user directory and selects all the users of the current team solution.
<table>View Enforces column-level and row-level security for a user table.
<table>WorkflowView Exposes selected columns from the <table>Workflow table. Filters only those rows in the workflow table that describe actions on which the user has execute permissions.