Skip Headers

Oracle9i Discoverer Administrator Administration Guide
Version 9.0.2

Part Number A90881-02
Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index

Go to previous page Go to next page

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

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

Role

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.

(Drop down user/role list)

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.

Warn user if predicted time exceeds _ minutes

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.

Prevent queries from running longer than _minutes

Use this field to limit the query time for the selected user.

Limit retrieved data to _rows

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.


Go to previous page Go to next page
Oracle
Copyright © 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index