Skip Headers

Oracle9iAS Discoverer Plus User's Guide
Version 9.0.2

Part Number A90879-02
Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index

Go to previous page Go to next page

17
Sharing workbooks

This chapter explains how to share workbooks with other Discoverer users, and contains the following topics:

About sharing workbooks

Discoverer makes it easy for you to share workbooks with other users. For example, you might have created a workbook for analyzing web site traffic and want your colleagues to be able to analyze the data

When you share one of your Discoverer workbooks, you give other Discoverer users read-only access to that workbook. Read-only access enables Discoverer Plus and Discoverer Viewer users to:

When you share worksheets, you are sharing the query definition, not the query data itself. The query data that users can access is dependent on users' database access privileges.

Discoverer users can only access worksheets containing data to which they have database access privileges. In other words, if you share a workbook with multiple users, each user will only see the worksheets containing data to which they have database access.

When you share a workbook, you explicitly specify the Discoverer users that have access to that workbook. Only the users that you specify will have access to the workbooks that you choose to share with them. If you want to share results with all users, you can use the Public user option.

When sharing workbooks with other Discoverer users, you can grant access rights in two ways:

Notes:

How to share a workbook with multiple Discoverer users

Often, you will want to share a single workbook with multiple Discoverer users. For example, you might have scheduled a weekly report that you want to provide to colleagues in your department.

To share a workbook with multiple Discoverer users:

  1. Choose File | Manage Workbooks | Sharing to display the Share Workbooks dialog.

  2. Display the "Share Workbook dialog: Workbook -> User tab".


    Text description of share1.gif follows.
    Text description of the illustration share1.gif

  1. Use the Workbook drop down list to specify which workbook you want to share.

    Note: The Workbook drop down list only displays workbooks that you have created.

  2. To the share the specified workbook, move the users from the Available list to the Shared list.

    Hint: You can select more than one user by pressing the Ctrl key and clicking another user.

  3. Click OK to share the workbook with the Discoverer users that you specified and close the Share Workbooks dialog.

    The users specified will be able to access the workbook when they next connect to Discoverer.

Notes

How to share multiple workbooks with a single Discoverer user

Often, you will want to share multiple workbooks with a single Discoverer user. For example, you might have created a set of reports that you want to provide to a single colleague in another department.

To share multiple workbooks with a single Discoverer user:

  1. Choose File | Manage Workbooks | Sharing to display the Share Workbooks dialog.

  2. Display the "Share Workbook dialog: User -> Workbook tab".


    Text description of share2.gif follows.
    Text description of the illustration share2.gif

  1. Use the User drop down list to select the user that you want to share the workbooks with.

  2. To share workbooks with the specified user, move the workbooks from the Available list to the Shared list.

    Hint: You can select more than one workbook by pressing the Ctrl key and clicking another workbook.

  3. Click OK to share the selected workbooks with Discoverer user and close the Share Workbooks dialog.

    When the user that you selected next connects to Discoverer, they will have access to the workbooks that you specified.

Notes


Go to previous page Go to next page
Oracle
Copyright © 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index