Share via

modDropRowPermissions

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

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