The modPermissions Table

See Also

The modPermissions table is used to define row-level security on user tables and workflow tables. It associates database rows or workflow rows with solution database security roles.

Every row in the permissions tables describes the permissions granted to a database role for an individual item or row. If no permissions are specified for an item, all users of that team solution can access it.

For more information database roles and security, see Security Permissions Model and Creating Database Roles.

Caution   You should not alter the modPermissions table manually. Use the Access Workflow Designer and the Team Solutions Manager to make changes. Schema integrity is not guaranteed if you make manual changes to any solutions system tables.

The modPermissions database table contains a number of columns used by the team solutions. The following table lists those columns and their data types and provides a brief description of each.

Column Data type Description
TableID int A unique identifier for the user table.
RowID int The unique identifier of the row in the user table.
RoleName sysname(128) The name of the database role to which permissions are granted.
Type int Type of permissions: 

1   = Select

2   = Update

4   = Insert

8   = Delete

16 = Execute

32 = Grant

Note   In the Access Workflow Designer, these SQL Server permissions are mapped to: 

R = Select

RW = Select and Update
rowguid uniqueidentifier Unique identifier used for replication.