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.

[@TableName =] 'name', 

[@IndexColName =] 'index' output

Returns the name of the column that is used to uniquely identify the rows in a table for row-level permissions. Exists in the solution database.

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