How To

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