Excluding Users

Application Query Security is applied to all users (*PUBLIC), which encompasses all users. Some users may need to perform an open ended fetch for a particular reason. Therefore, some users need to be excluded from the application query security. The Exclude Users form enables you to exclude one or more users from the application security record.

Use these steps to exclude users:

  1. Access your web client application.

  2. In the Fast Path field, type P00950.

    The Work with User/Role Security form displays. Any query security instances that have already been set up display in the grid.

  3. From the Form menu, select Set Up Security, and then App Query Security.

    The Work with Application Query Security form displays. Any query security instances that have already been set up display in the grid.

  4. From the grid, select the existing record, and then click the Row exit.

  5. Click Exclude Users.

    The Exclude Users form displays.

  6. In the User ID field, enter the ID of the user you want to exclude from the Application Query Security you have set up for the record you selected.

  7. Click OK.