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:
The Define Warehouse User notebook opens.
Tutorial User
The name identifies the user ID within the Data Warehouse Center. This name can be up to 80 characters-including spaces.
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. |
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:
|
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. |
Tip: | You can clear this check box to temporarily revoke a user's access to the Data Warehouse Center, without deleting the user definition. |