How to revoke permissions on an object (Enterprise Manager)

How to revoke permissions on an object (Enterprise Manager)

To revoke 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 revoked, click one of the following:
   • Tables
     
     
   • Views
     
     
   • Stored Procedures
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. Click List all users/user-defined database roles/public, and then 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

Revoking Permissions