modEnumRowPermissions

See Also

[@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