Share Workbooks dialog: Workbook -> User tab

Use this dialog to share a single workbook with multiple database users (or roles) in one operation. For example, you might have created a workbook for analyzing sales and want to publish the workbook to a group of Discoverer Viewer users.

You can also use this dialog to see the workbooks that Discoverer users have access to.

Note: To give a single Discoverer user access to many workbooks in one operation, use the "How to share multiple workbooks with a single Discoverer user".

This dialog is also displayed as:
Share Workbook dialog

For more information, see:

"What are workbooks?"

"About sharing workbooks and security"


This field displays the name of the currently selected workbook (that you selected in the Manage Workbooks dialog). To share a different workbook, click Cancel and select a different workbook in the Manage Workbooks dialog.

Note: Scheduled workbooks have a clock icon in front of the workbook name. If you share a scheduled workbook, you share all scheduled workbook results sets produced by that scheduled workbook. For more information, see "What are scheduled workbooks?".


This area enables you to select users with which to share the workbook.

  • Search

    Use these fields to search for the database users (or roles) to whom you want to share workbooks, as follows:

    • Use the left hand drop down list to specify whether to search for database users or roles (or both).

    • Use the middle drop down list to specify the criteria you want to use to match database users (or roles). For example, you might want to search for database usernames beginning with a particular letter.

    • Use the right hand field to specify text in the name of a database user (or role) you want to search for. If you leave this field empty and click Go, all database users (or roles) are displayed (depending on which value is selected in the left hand drop down list).

    Note: Database users are represented by a person icon. Database roles are represented by a mask icon. For more information about selecting database users (or roles), see "About sharing workbooks".

  • Go

    Use this button to display in the Available list the database users (or roles) that match your search criteria in groups of 100.

  • Available

    Use this list to specify the database users (or roles) you want to give access to the selected workbook. To give access, move names from the Available list to the Shared list.

    Note: You can select multiple Discoverer users by pressing the Ctrl key and clicking another Discoverer user.

  • Shared

    Use this list to see the users that have access to the selected workbook. To revoke access, move Discoverer user names from the Shared list back to the Available list.

  • Previous

    Use this button to display the previous 100 database users (or roles).

  • Next

    Use this button to display the next 100 database users (or roles).


This field displays additional information about the currently selected workbook, which was entered using the "Workbook Properties dialog". Use this information to help you decide which workbook you want to share. This area is blank if no description is available.

Hint: To add or edit the description, update the workbook properties (for more information, see "How to view and update a workbook's properties").