Privileges dialog: Privileges tab

Use this tab to grant privileges to users or roles (role is replaced with responsibility for Oracle Applications users). For example, to enable Discoverer Plus and Discoverer Desktop and Discoverer Plus end users to create and edit queries, drill down, and drill out, but not allow them to save workbooks to the database.

For more information, see:

"About Discoverer and security"

Show privileges 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.

Use the drop down list to choose the user or role whose privileges you want to configure. For example, choose jchan to display the privileges for jchan in the Privilege field.

Administration Privilege

Use this check box to grant or revoke the ability of the currently selected user or role to use Discoverer Administrator.

Desktop and Plus Privilege

Use this check box to grant or revoke the ability of the currently selected user or role to use Discoverer Desktop and Discoverer Plus.

Use the check boxes in the fields under the Administration Privilege and Desktop and Plus Privilege check boxes, to grant or revoke privileges to the currently selected user or role as follows:

• To grant Discoverer Administrator privileges, select individual privileges in the group under the Administration Privilege check box. These privileges apply to Discoverer Administrator.

• To grant Discoverer Desktop and Discoverer Plus privileges, select individual privileges in group under the Desktop and Plus Privilege check box. These privileges apply to Discoverer Desktop and Discoverer Plus.

(description field)

This field displays a brief description about the currently selected privilege.

Select an Oracle system profile

Use this drop down list to specify an Oracle system profile to apply to the user. This allows you to apply pre-defined sets of privileges to users and roles.

• system profiles are Oracle-specific

• if you are using a non-Oracle database, this field is grayed out

Notes

• The Roles check box and the Oracle system profile field are unavailable if you are not using an Oracle database.

• If your current user ID does not have access to the table DBA_ROLES (Oracle databases), only a subset of roles and responsibilities might be visible in the drop down list.

• Administration privilege types available:

  Privilege Name	Description
  Administration Privilege	Granting this privilege, allows the user or role to log in to Discoverer Administrator. Note that to allow the user to access the features in Discoverer Administrator, you must select individual Administration features (privileges) listed below this privilege. This check box must be selected in order to grant any of the privileges listed below.
  Format Business Area	Granting this privilege, allows the user or role to edit formatting information in an existing business area to which they have access. Such formatting information includes folders, summary folders, joins, and items. Granting this privilege allows the user or role to specify names, descriptions, default format masks and placement.
  Create/Edit Business Areas	Granting this privilege, allows the user or role to create and modify business areas, folders, summary folders, joins, calculations, conditions, hierarchies and item classes.
  Create/Edit Summaries	Granting this privilege, allows the user or role to create summary folders through Discoverer Administrator. Also requires database resource privileges.
  Set Privilege	Granting this privilege, allows the user to maintain and modify user privileges using this dialog box. Note: You cannot grant this privilege to a role.
  Manage Scheduled Workbooks	Granting this privilege, allows the user or role to monitor and maintain the schedule for scheduled workbooks.

• Desktop and Plus privilege types available:

  Privilege Name	Description
  Desktop and Plus Privilege	Granting this privilege, allows the user or role to log in to Discoverer Desktop and Discoverer Plus. Note that to allow the user to access the features in Discoverer Desktop and Discoverer Plus, you must select individual Desktop features (privileges) listed below this privilege.This check box must be selected in order to grant any of the privileges listed below.
  Create/Edit Query	Granting this privilege, allows the user or role to create new worksheets (queries) and modify existing ones. Without this privilege, the user can only open and run existing (predefined) workbooks and worksheets.
  Collect Query Statistics	Granting this privilege, saves performance statistics when this user runs worksheets/workbooks (queries).If you clear this check box query prediction estimates might be less accurate. For more information, see "Predicting query performance".
  Item Drill	Granting this privilege, allows the user or role to drill to detail and related information in the worksheet. In addition to granting this privilege, you must create the drill using the Item Class wizard before the user will be able to use this function.
  Drill Out	Granting this privilege, allows the user or role to launch another application to see related information by drilling on an item in the worksheet. In addition to granting this privilege, you must create the drill using the Item Class wizard before the user will be able to use this function.
  Grant Workbook	Granting this privilege, allows the user or role to grant access to their workbooks so other users can run and view them.
  Schedule Workbooks	Granting this privilege, allows the user to schedule a workbook to run at a later time and at regular intervals (i.e., daily, weekly, monthly). Note: You cannot grant this privilege to a role.
  Save Workbooks to Database	Granting this privilege, allows the user or role to save the workbooks they create in the database. By default, Discoverer Desktop workbooks are saved on the user's hard drive.
  Change Password	Note: This privilege is not used in this release.