How to deny permissions on multiple objects to a user, group, or role (Enterprise Manager)

To deny permissions on multiple objects to a user, group, or role

1. Expand a server group, and then expand a server.
   
   
2. Expand Databases, and then expand the database to which the user, group, or role belongs.
   
   
3. Depending on the type of user, group, or role to which permissions will be denied, click either Users or Roles.
   
   
4. In the details pane, right-click the user or group to which permissions will be denied, point to All Tasks, and then click Manage Permissions. If you are denying permission to a role, right-click the role to which permissions will be denied, click Properties, and then click Permissions.
   
   
5. Click List all objects, and then select the permission to deny for each object.

   An 'X' indicates a denied permission. Only permissions applicable to the object are listed.

See Also

Denying Permissions