Use this tab to grant privileges to users or roles (role is replaced with responsibility for Oracle Applications users). For example, you can enable Discoverer Plus and Discoverer Desktop end users to create and edit queries, drill down, and drill out, but prevent them from saving workbooks to the database.
For more information, see:
"About Discoverer and security"
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 privileges you want to change. For example, choose jchan to display the privileges for jchan in the Administration Privilege and Desktop and Plus Privilege fields.
Use this check box to grant or revoke the ability of the currently selected user or role to use Discoverer Administrator.
Use this check box to grant or revoke the ability of the currently selected user or role to use Discoverer Desktop, Discoverer Plus, and Discoverer Viewer.
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 the group under the Desktop and Plus Privilege check box. These privileges apply to Discoverer Desktop, Discoverer Plus, and Discoverer Viewer.
This field displays a brief description about the currently selected privilege.
Select an Oracle system profile
Use this list to specify an Oracle system profile to apply to the user. This enables you to apply predefined sets of privileges to users and roles.
system profiles are Oracle-specific
if you selected a database role or an Oracle Applications responsibility in the Show privileges for field, this field is grayed out
If your current user ID does not have access to the table DBA_ROLES, only a subset of roles and responsibilities might be visible in the "Select User/Role dialog".
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 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, Discoverer Plus and Discoverer Viewer. Note that to allow the user to access the features in Discoverer Desktop, Discoverer Plus, and Discoverer Viewer you must select individual features (privileges) listed below this privilege. This check box must be selected 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, or have items with the Content Type set to <FILE>. |
| 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 (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.
Note: You cannot save Discoverer Plus workbooks to a file system. You can save them only to the database. |
| Change Password | Note: This privilege is not used in this release. |
| Create Link | Granting this privilege enables Discoverer end user to create their own drill links. A drill link is a way to access another worksheet or URL from a particular worksheet cell value. |