Privileges dialog: Query Governor tab

Use this tab to view and edit the query configuration for a specified user or role (role is replaced by responsibility for Oracle Applications users). For example, to limit the number of rows that can be retrieved for the user jchan.

For more information, see:

"Controlling access to information"

Show query limits for

User

Select this check box to display users in the drop down list to the right.

Role

Select this check box to display roles in the drop down list to the right.

The roles check box is only available when you are using an Oracle database.

(Drop down user/role list)

Use this drop down list to choose the user or role whose query limits you want to configure. For example, choose jchan to display the query limit settings for jchan in the Query Governor panel.

Query Governor

Warn user if predicted time exceeds: _ minutes

Select this check box to display a warning to the Discoverer end user if a query takes longer than the amount of time specified.

This privilege is only available when using an Oracle database.

Prevent queries from running longer than: _minutes

Select this check box to limit the query time for the selected user.

Limit retrieved data to: _rows

Select this check box to limit the number of rows a users query can return. The limit you set here is a maximum. The end user can set a limit that is lower. When a query has reached the maximum number of records set by you or the end user, the query stops and the data retrieved so far is returned to the end user. For example, if the check box is selected and the value 1000 is entered, only the first 1000 rows of a query are displayed on a Discoverer end user worksheet.