How to grant permissions on multiple objects to a user, group, or role (Enterprise Manager)

To grant permissions on multiple objects to a user, group, or role

1. Expand a server group; then expand a server.
2. Expand Databases; then expand the database to which the user, group, or role belongs.
3. Click Users or Roles, depending on the type of user, group, or role to which permissions will be granted.
4. In the details pane, right-click the user, group, or role to which permissions will be granted, point to All Tasks, and then click Manage Permissions.
5. Select List all objects.
6. Select the permission to grant for each object. A check indicates a granted permission. Only permissions applicable to the object are listed.

See Also

Allowing Access by Granting Permissions