How to allow access by granting permissions (Enterprise Manager)

To allow access by granting 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, click one of the following:
   • Tables
     
     
   • Views
     
     
   • Stored Procedures
4. In the details pane, right-click the object on which to grant permissions, 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 grant each user.

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

See Also

Granting Permissions