How to revoke permissions on an object (Enterprise Manager)

To revoke 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 revoked.
4. In the details pane, right-click the object to which access will be revoked, point to All Tasks, and then click Manage Permissions.
5. Select List all users/DB roles.
6. Select the permission to revoke from each user. An empty box indicates a revoked permission. Only permissions applicable to the object are listed.

See Also

Deactivating Established Access by Revoking Permissions