Business Intelligence Tutorial

Defining a warehouse user

In this exercise, you will define a new user to the Data Warehouse Center.

The Data Warehouse Center controls access with user IDs. When a user logs on, the user ID is compared to the warehouse users that are defined in the Data Warehouse Center to determine whether the user is authorized to access the Data Warehouse Center. You can authorize additional users to access the Data Warehouse Center by defining new warehouse users.

The user ID for the new user does not require authorization to the operating system or the warehouse control database. The user ID exists only within the Data Warehouse Center.

To define a warehouse user:

  1. In the left panel of the main Data Warehouse Center window, expand the Administration folder.
  2. Expand the Warehouse Users and Groups tree.
  3. Right-click the Warehouse Users folder and click Define.

    The Define Warehouse User notebook opens.

  4. In the Name field, type the business name of the user:
    Tutorial User
    

    The name identifies the user ID within the Data Warehouse Center. This name can be up to 80 characters-including spaces.

  5. In the Administrator field, type your name as the contact for this user.
  6. In the Description field, type a short description of the user:
    This is a user that I created for the tutorial.
    
    Tip:You can use the Description and Notes fields to provide metadata about the definitions for your warehouse. You can then publish this metadata in an information catalog for the warehouse. Users of the warehouse can search the metadata to find the warehouse that contains the information they need to query.
  7. In the User ID field, type the new user ID:
    tutuser
    

    The user ID must be no longer than 60 characters and cannot contain spaces, dashes, or special characters (such as @, #, $, %,>, +, =). It can contain the underscore character.
    Specifying a unique user ID:The user ID you specify must be unique to the data warehouse.

    To determine if a user ID and password is unique:

    1. From the main Data Warehouse Center window, expand the Administration tree.
    2. Click on the Warehouse Users folder. All of the user IDs for the data warehouse appear in the right panel. Any ID that doesn't appear in the right panel is a unique ID.

  8. In the Password field, type the password:
    password
    

    Passwords must be a minimum of six characters and cannot contain spaces, dashes, or special characters.
    Tip:You can change your password on this page of the user notebook.

  9. In the Verify Password field, type your password again.
  10. Verify that the Active User check box is selected.
    Tip:You can clear this check box to temporarily revoke a user's access to the Data Warehouse Center, without deleting the user definition.

    The Define Warehouse User notebook
  11. Click OK to save the warehouse user and close the notebook.


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