Share via

modEnumRowPermissions

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

[@TableName =] 'table', 

[@RowId =] 'rowid', 

[@RoleName =] 'role'

Lists row permissions for a database role. Exists in the solution database.

Parameters

[@TableName =] 'table'

The table for which row permissions are modified.

[@RowId =] 'rowid'

The ID of the row for which permissions are modified.

[@RoleName =] 'role'

The database role for which permissions are modified.

Remarks

Returns a result set with the permissions for the specified row. If a role name is provided, scopes the permissions for that role. The permissions types are:

R = SELECT
W = UPDATE
D = DELETE
X = EXECUTE
G = GRANT

Example

The following example lists the permissions for row 14 in the Orders table.

EXEC modEnumRowPermissions 'Orders', 14