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 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

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.

(Drop down user/role list)

User this 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 box.

Privilege

Use the check boxes in this panel to grant or revoke privileges to the currently selected user or role.

• To grant Administration privileges, select the Administration check box, then select individual privileges in the Administration group.

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

Description

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

Select a system profile

Use this drop down list to specify a 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 dimmed.

Notes

• The roles label and the 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 may be visible in the drop down list.

• Privilege types:

  Privilege Name	Description
  Administration	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) in this list. This option must be selected in order to grant any of the privileges listed under Administration.
  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, 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, joins, calculations, conditions, hierarchies and item classes.
  Create Summaries	Granting this privilege, allows the user or role to build summary tables through Discoverer Administrator. Also requires database resource privileges.
  Set Privilege	Granting this privilege, allows the user or role to maintain and modify user/role privileges using this dialog box.
  Manage Schedule Workbooks	Granting this privilege, allows the user or role to monitor and maintain the schedule for scheduled workbooks.
  Discoverer Plus	Granting this privilege, allows the user or role to log in to Discoverer Plus. Note that to allow the user to access the features in Discoverer Plus, you must select individual Discoverer Plus features (privileges) in this list.This option must be selected in order to grant any of the privileges listed under Discoverer Plus.
  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).This information is only saved if you have set up the Query Statistics feature. See your Administration Guide for details about this feature.
  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 or role to schedule a workbook to run at a later time and at regular intervals (i.e., daily, weekly, monthly).
  Save Workbooks to Database	Granting this privilege, allows the user or role to save the workbooks they create in the database. By default, workbooks are saved on the user's hard drive.