How to prevent access by denying permissions (Enterprise Manager)

To prevent access by denying permissions (on an object)

1. Expand a server group; then expand a server.
2. Expand Databases; then expand the database to which the object belongs.
3. Click Tables, Views, or Stored Procedures, depending on the type of object to which access will be denied.
4. In the details pane, right-click the object to which access will be denied, point to All Tasks, and then click Manage Permissions....
5. Select List all users/DB roles.
6. Select the permission to deny each user. An ‘X’ indicates a denied permission. Only permissions applicable to the object are listed.

See Also

Preventing Access by Denying Permissions