Determining which QMF catalog user profile to use
When QMF for Workstation or QMF for WebSphere® connects to a data source on behalf of a user, the user ID and password they provide are validated first by the data source. If the user information is valid, then the user ID is looked up in the user profile table, RDBI.PROFILE_TABLE.
The RDBI.PROFILE_TABLE is created at installation. All user IDs
that are included in the Q.PROFILES table at the time of installation
are included in the RDBI.PROFILE_TABLE.
Note: After the initial copy
of Q.PROFILES, any user ID added directly to Q.PROFILES is not automatically
added to the RDBI.PROFILE_TABLE. You must add those new user IDs using
a QMF Administrator
product (Workstation or WebSphere).
The RDBI.PROFILE_TABLE includes the following columns:
| CREATOR | ENVIRONMENT | TRANSLATION | RESOURCE GROUP |
|---|---|---|---|
| userID | WINDOWS | English | TECH |
| userID | NULL | English | SALES |
| SYSTEM | WINDOWS | English | BASIC |
| SYSTEM | NULL | English | SYSTEM |
When you create a new user profile, an entry is made in the table
for the user ID that you enter. The Creator column
is the user ID that you enter, the Environment and Translation columns
are filled for you based on the environment and language of the host
system. The Resource Group column contains the resource
limits group to which this user is assigned.