Business Intelligence Tutorial

Granting privileges

To grant privileges to the TUTWHS database:

  1. From the DB2 Control Center, expand the objects in the TUTWHS database until you see the Tables folder.
  2. Click the Tables folder. In the right panel, you will see all the tables in the database.
  3. Right-click on the LOOKUP_MARKET table, and click Privileges.

    The Table Privileges window opens.

  4. Click Add User.

    The Add User window opens.

  5. Select a user or enter a name. Click OK. The user is added to the User page.
  6. Select one or more users. To grant all privileges to the selected users, click Grant All. To grant individual privileges, use the Privileges list boxes.
  7. Click Apply to process your request.
  8. Close the Table Privileges window.


[ Top of Page | Previous Page | Next Page | Table of Contents ]