Share via

modGrantRowPermissions

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

[@Permissions =] 'permissions'

Sets row permissions for a specified 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.

[@Permissions =] 'permissions'

The permissions to be set for the role on the specified row.

Remarks

All parameters are required. If the row has existing permissions for the role, they are replaced with the ones specified in the Permissions parameter. The permissions types are:

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

Example

The following example grants SELECT and UPDATE permissions for Authors on row 14 in the Orders table.

EXEC modGrantRowPermissions 'Orders', 14, 'Authors', 'RW'