modGetPermissionsJoinColumn
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.
Returns the name of the column that is used to identify uniquely the rows in a table for row-level permissions. Exists in the workflow-enabled database.
[@TableName =] 'name',
[@IndexColName =] 'index' output
Parameters
- [@TableName =] 'name'
Name of the table. - [@IndexColName =] 'index'
Output parameter that holds the name of the column that joins the table with the permissions table.
Remarks
The column should be of type int or numeric. The procedure looks first for a single-column primary key and then for an identity column.
Example
The following example looks for the join column for the Category table. The value returned in @JoinColumn is CategoryID:
EXEC modGetPermissionsJoinColumn 'Category', @JoinColumn
See Also
Stored Procedures | Workflow Application Infrastructure | ModSystem Database Tables | Workflow-Enabled Database Tables | Views