Export (0) Print
Expand All
Expand Minimize

How to grant, deny, or revoke permissions on multiple objects to a user-defined role (Enterprise Manager)

SQL Server 2000

How to grant, deny, or revoke permissions on multiple objects to a user-defined role (Enterprise Manager)

To grant, deny, or revoke permissions on multiple objects to a user-defined role

  1. Expand a server group, and then expand a server.

  2. Expand Databases, and then expand the database to which the role belongs.

  3. Click Roles.

  4. In the details pane, right-click the user-defined role to which permissions will be granted, denied, or revoked, and then click Properties.

  5. Under Names, click Permissions.

  6. Click List all objects, and then select the permission to grant, deny, or revoke on each object.

    A checkmark indicates a granted permission; an 'X' indicates a denied permission; and an empty box indicates a revoked permission. Only permissions applicable to the object are listed.

Show:
© 2014 Microsoft