Skip Headers
Oracle® Fusion Middleware Administrator's Guide for Oracle Business Intelligence Discoverer
11g Release 1 (11.1.1)

Part Number B32519-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

Privileges dialog: Scheduled Workbooks tab

Use this tab to specify scheduled workbook settings for a specified user or role (role is replaced by responsibility for Oracle Applications users). For example, to limit the number of workbooks that a user can schedule, or to define the expiry date of scheduled workbooks.

For more information, see:

"Scheduling Workbooks"

"About Discoverer and security"

"How to set scheduled workbook limits"

Show scheduling limits for

Use the Select button next to this field to display the "Select User/Role dialog" where you can search for and select the user or role whose scheduling limits you want to change. For example, choose jchan to display the scheduled workbook settings for jchan.

Note: If you select a user or role that does not have schedule workbook privileges, the configuration details are disabled. If you want the user or role to have this privilege, see "How to specify a user or role (responsibility) to perform a specific task":

Select the user to own the tables which store any workbook results

Use this drop down list to select the user name of the database user that will own the scheduled workbooks tables.

<Is user required to schedule workbooks?>

Use these options to specify if or when a user is required to schedule workbooks.

Limit number of scheduled workbooks

Use this check box to specify the maximum number of workbooks that a user can schedule.

Note: This option enables you to prevent users from submitting so many scheduled workbooks that no other jobs on the DBMS_JOB queue can run

Expire results

Use this check box to limit the lifetime of scheduled workbook results (days). Results due for deletion are deleted when the user disconnects from the EUL.

Commit size

Use this check box to specify the number of rows that are committed to the result table at a time, when Discoverer processes the scheduled workbook. For example, if 1000 rows need to be written and the Commit size is 100, 10 writes are performed. On large result sets, server performance is improved by setting the commit size higher than the default (although little gain will be achieved by setting the Commit size higher than 1000).

Restrict the hours during which a workbook may be scheduled

Use this check box to specify when a user can schedule workbooks. This could be exploited to prevent users from scheduling workbooks at peak times.