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, and then expand a server.
   
   
2. Expand Databases, and then expand the database to which the user, group, or role belongs.
   
   
3. Depending on the type of user, group, or role to which permissions will be granted, click either Users or Roles.
   
   
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. Click List all objects, and then select the permission to grant each object.

   A check indicates a granted permission. Only permissions applicable to the object are listed.

See Also

Granting Permissions