Export (0) Print
Expand All
Expand Minimize

How to allow access by granting permissions (Enterprise Manager)

SQL Server 2000

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

Show:
© 2015 Microsoft