Oracle9i Discoverer Administrator Administration Guide Version 9.0.2 Part Number A90881-02 |
|
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"
Use this check box to display users in the drop down list to the right.
Use 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.
User 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 area.
Use this field 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.
Use this field to limit the query time for the selected user.
Use this field to limit the number of rows a users query may 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.
|
Copyright © 2002 Oracle Corporation. All Rights Reserved. |
|