How to prevent access by denying permissions (Enterprise Manager)

To prevent access by denying permissions (on an object)

1. Expand a server group, and then expand a server.
   
   
2. Expand Databases, and then expand the database to which the object belongs.
   
   
3. Depending on the type of object to which access will be denied, click one of the following:
   • Tables
     
     
   • Views
     
     
   • Stored Procedures
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. Click List all users/user-defined database roles/public, and then select the permission to deny each user.

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

See Also

Denying Permissions