Determining database access with user profiles
QMF for Windows determines 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 database
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 database server
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 database server.
For open enrollment:
- User ID matches a user profile. User profile names a resource
limits group. Resource limits group exists. Access to database server
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 database
server 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 database server 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 server based on the limits set for set for the <default> resource
limits group.
