Setting Up DataBrowser Query Security

You set up databrowser query security records if you want to secure users from entering wide open queries from the Data Browser. Similar to Application Query Security, you can specify required filter fields and QBE columns the user must enter when querying via the Data Browser.

Use these steps to set up DataBrowser query security:

1. Access your web client application.

2. In the Fast Path field, type P00950.

   The Work with User/Role Security form displays.

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

   The Work with Application Query Security form displays.

4. From the Form menu, click Add Application.

   The Setup Application Query Security form displays.

5. From the Form menu, click Add Application, and then select Databrowser.

   Notice that DATABROWSE already displays in the Application Name field, and the databrowser options display.

   • At Least One Form Filter Field or QBE Field

     Select this option if users must enter search criteria into at least one filter field on the form or QBE column.

   • Configured Fields

     Select this option to select one or more required form filter fields or QBE fields for the form.

6. Select one of the following Message Types:

   • Error

     Select this option if you want an error message to pop up when users try to execute a query that does not satisfy the Field Entry Requirements specified previously.

   • Warning

     Select this option if you want a warning message to pop up when users try to execute a query that does not satisfy the Field Entry Requirements specified previously.

7. Click OK.