modGrantRowPermissions

See Also

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