modDropRowPermissions

See Also

[@TableName =] 'table', 

[@RowId =] 'rowid', 

[@RoleName =] 'role'

Removes row permissions for a database role or for all roles. 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

If all parameters are specified, it deletes the permissions the role has on the selected row. If role is not specified, it deletes permissions for all roles on the row. If the row ID is not specified and the user is member of db_owners, then it deletes the row permissions for all rows in the table.

Example

The following example deletes all role permissions on row 14 in the Orders table.

EXEC modDropRowPermissions 'Orders', 14