Share via

The modPermissions Table

  • 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.

The modPermissions table is used to define row-level permissions on user tables and workflow tables. It associates table rows with workflow application 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 workflow application can access it.

**Note   **You should not alter the modPermissions table manually. Use the Workflow Designer for SQL Server and the Workflow Manager to make changes. Schema integrity is not guaranteed if you make manual changes to any system tables.

The following table lists the modPermissions table 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 Workflow Designer for SQL Server, these SQL Server permissions are mapped to:
R = Select
RW = Select and Update
rowguid uniqueidentifier Unique identifier used for permissions.

See Also

Workflow-Enabled Database Tables | The modColumns Table | The modObjects Table | The modObjectTypes Table | The modProperties Table (Workflow-Enabled Database) | The modUserRoles Table | The Workflow Tables | The WorkflowActions Tables | The Lookup Table | Security Permissions Model | Creating Database Roles