How to prevent access by denying permissions (Enterprise Manager)

How to Install SQL Server 2000

How To

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