Assigning users to QMF catalog resource limits groups

To assign a user to a QMF catalog-based resource limits group you must first define a user profile for the user, and then you assign the user profile to the resource limits group.

About this task

The order in which you create user profiles or resource limits groups does not matter. You can create user information first, then create resource limits groups. You can create resource limits groups first, then user information. This flexibility is intended as creating and editing user information and resource limits group assignments is an ongoing process as the needs of your organizations change.

Note: The users with the specified <NULL> or <WINDOWS> value in the ENVIRONMENT column and the users with values that match Language User Interface of the Preferences in the TRANSLATION column are available for assigning the resource limits group. For more information, see Determining which QMF catalog user profile to use.

To assign users to a QMF catalog resource limits group:

Procedure

  1. From the Repository Explorer view, right-click a data source. Select Properties from the pop-up menu. The Properties for [data source] window opens. Click the Resource Limits folder. The Resource Limits window opens. There are two pages. Click the Resource Limits tab. Click Refresh List. Select a resource limits group from the list of available resource groups. Click Assign. If the selected resource limits group is not Default, the Assign User Profiles to [resource limits group name] window opens.
  2. Click Refresh List. The user profiles that have been created for the data source and are available for assignment are listed in the Not assigned list box including the SYSTEM user profile. You can modify the user profiles that are listed using the Show User Profiles with "creator" matching field. In this field you can specify the user ID of a specific user profile or a wildcard character. A percent (%) sign will generate a list of all user profiles that have been created for the data source. Click Refresh List to initiate the search. All the user profiles are stored in RDBI.PROFILE_VIEW that match the value you entered are retrieved. It can be populated from RDBI.PROFILE_TABLE or Q.PROFILES. For more information about the RDBI.PROFILE_TABLE or Q.PROFILES tables, see Creating database objects for the QMF catalog. The users that have been assigned to the selected resource limits group are listed in the Assigned list box.
  3. If the user ID that you want to assign to a resource limits group is not listed in the Not assigned list, click Create New to create a new user profile. The New Profile window opens. In the Creator field, specify a valid user ID for a user. Click OK. The New Profile window closes. The new user profile is created and assigned to the resource limits group. Control returns to the Assign User Profiles to [resource limits group name] window.
  4. Select the user that you want to assign to the resource limits group from the Not assigned list. Click Assign. The user is moved to the Assigned list. To move all the users from the Not assigned list to the Assign list, click Assign All.
  5. To remove a user from the resource limits group, select the user from the Assigned list. Click Unassign. The user is moved to the Not assigned list. To remove all the users from the Assigned list and move them to the Not assigned list, click Unassign All.
  6. Click OK. Your additions or changes to the resource limits group user assignments are saved.

Results

Note: You can also make user assignments to resource limits groups, and create, edit and delete user profiles, from the User Profiles page of the Resource Limits window.