Member Avatar for haria_kishore

Hi Guys

I have designed reports in Discoverer Plus and the users are viewing the report using viewer.

My need is that suppose there is a report which is made. Now if some user views the report by changing the layout and save the changes. Now problem is the change done by the user is reflected when any other user opens that report.

Is it possible to create some private kind of connection where a particular user can do the changes but is not reflected in the actual set of reports created

Is it possible to do something with private and public connections

Please help me out in this

  • 4 Contributors
  • 4 Replies
  • 530 Views
  • 5 Months Discussion Span
  • Latest Post Latest Post by alit2002

Dani AI

Generated

Short, practical fix and why it happens

The situation you describe happens because the workbook stored in the Discoverer End User Layer (EUL) is a shared object and users who have the right to save can overwrite it. Rather than trying to create a special “private connection,” make the published workbook read-only for consumers and force personal changes to be saved as a copy. The Discoverer Administrator lets you control exactly which tasks a user or role can perform (including saving workbooks). (docs.oracle.com)

What to change (admin steps)

In Discoverer Administrator open the Privileges dialog for the user or role that contains your viewers. Under the Desktop/Plus privileges, clear the Save Workbooks to Database privilege (and, if you want strictly run-only access, also clear Create/Edit Query). Users without the save privilege can open and run the published workbook but cannot overwrite it. After changing privileges, test with a user account that belongs to that role. (docs.oracle.com)

How users keep personal layouts

If end users need their own layout, instruct them to use File -> Save As and give the workbook a new name (or save locally) so they get a private copy; the original master workbook remains untouched. Discoverer supports saving a workbook under a new name so personal copies are straightforward to create. (docs.oracle.com)

Troubleshooting and best practice

If a change still appears to propagate, check: role membership (users may belong to multiple roles), whether users are using Discoverer Plus rather than Viewer (Plus allows more editing), and whether anyone has the Save/Grant privileges at the role level. Keep a single “master” workbook owned by an admin account and use a naming/version convention (master_v1) so accidental overwrites are easy to spot and restore. (appservgrid.com)

References: Oracle Discoverer documentation on saving workbooks and the Privileges dialog.

Recommended Answers

All 4 Replies

Member Avatar for jwenting

nope. Discoverer reports are the same for everyone who has access to them.

Member Avatar for alit2002

I believe in Discoverer Administrator you can restrict the privileges of users so they can't change your report. If they make a change they have to save it under a new name. Might be worth looking into.

Member Avatar for simplesanju

hi oracle discoverer professional

given errors encountered on windows - Vista Machine no such error is being reported on windows- XP.

Please provide some METALINK etc. for such error occurrences..

1)java.lang.arrayindexoutofbondsexception

2)java.lang.illegalstateexception

3)unexpeted:java.lang.runtimeexception: unexcepted:
java.lang.illegalstateexception:missing eventsupport connect on:
oracle disco.model.corbaserver.worksheetlnfompl@f94934
(sheet1,siworkbook 11051322080)

4)an internal error has this persists,please
contact your discoverer manager

5)contact with discoverer server has been
continue your work,please restart discoverer
this problem persists,please contact your oracle
application server administrator

Member Avatar for alit2002

Hi

This could be connected to the version of Discoverer that you're using as there isn't much Oracle software that's certified to work with Windows Vista.

I need to know what version of Discoverer you have and is vista running on a 32 bit platform etc.

Regards

Alistair

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.