Determining database access with QMF catalog user profiles
QMF for Workstation and QMF for WebSphere® determine which
resource limits group to use by locating the user's profile from the RDBI.PROFILE_TABLE,
finding the resource limits group name in the Resource Group column of the table,
then finding that resource limits group in the RDBI.RESOURCE_TABLE, where the resource limits and
schedule are retrieved.
When you are setting up your user profiles for your environment, there are many permutations that can be used to control data source access. The following summarizes some of the different combinations that you might use:
For restricted enrollment:
- User ID matches a user profile. User profile names a resource limits group. Resource limits group exists. Access to data source is based on the resource limits and schedule for the group.
- User ID does not match a user profile. There is no default user profile called SYSTEM. User is denied access to the data source.
For open enrollment:
- User ID matches a user profile. User profile names a resource limits group. Resource limits group exists. Access to data source is based on the resource limits and schedule for the group.
- User ID does not match a user profile. There is a default user profile called SYSTEM. The default user profile SYSTEM names a resource limits group. The resource limits group exists. Access to data source is based on the resource limits and schedule for the group.
- User ID matches a user profile. No resource limits group is assigned. Access to the data source is based on the limits set for the default resource limits group.
- User ID does not match a user profile. There is a default user profile called SYSTEM. There is no resource limits group that has been defined for the SYSTEM user profile. User has access to the data source based on the limits set for the default resource limits group.