Business Intelligence Tutorial

Lesson 13. Authorizing users to the warehouse database

In this lesson, you will define privileges that authorize users to the warehouse database. Security for the warehouse database is managed within DB2 Universal Database. It is separate from the Data Warehouse Center security.

Access within DB2 Universal Database is managed by administrative authorities and user privileges within the database manager. Authorities are usually granted at the database level, and privileges are usually granted for objects within the database (for example, tables).

Privileges are controlled by users with SYSADM or DBADM authority, or by the creator of the object. You can grant privileges to users for the TUTWHS database because you are its creator.

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 Apply. The user is added to the User page.
6. Click OK to return to the Table Privileges window.
7. 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.
8. Click Apply to process your request.

What you just did

In this lesson, you authorized users to use the LOOKUP_MARKET table. In the next lesson, you will catalog the metadata that you have defined in the Data Warehouse Center, so that the users that you authorized in this lesson can find the data that they need more easily.