When QMF for Windows (QMF for WebSphere or QMF for Report Center) connects to a database server on behalf of a user, the user ID and password they provide are validated first by the database server. If the user information is valid, then QMF for Windows looks up the user ID in the user profile table, RDBI.PROFILE_TABLE.
The RDBI.PROFILE_TABLE is created when QMF for Windows is installed by copying the Q.PROFILE table. All user IDs that are included in the Q.PROFILE table at the time of installation, are included in the RDBI.PROFILE_TABLE.
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 fields are filled for you based on the environment and language of the system where QMF for Windows Administrator is installed. The Resource Group is the resource limits group to which this user is assigned.