Home » Developer & Programmer » Reports & Discoverer » Discoverer Security
Discoverer Security [message #87882] Tue, 09 October 2001 07:40 Go to next message
Glen
Messages: 7
Registered: October 2000
Junior Member
Is there a way to setup Discoverer without granting excessive security authorities?

My development team is asking for select all tables, create/drop tables/Resource and many other ALL/ANY authorities our shop does not allow.

Any help would be appreciated.

----------------------------------------------------------------------
Re: Discoverer Security [message #87883 is a reply to message #87882] Thu, 11 October 2001 05:30 Go to previous message
Todd McCutcheon
Messages: 2
Registered: October 2001
Junior Member
Glen,

What we do is have a DEVELOPMENT instance for the developers that has all the authorities you mention. The PRODUCTION instance has the authorities granted to just those tables that are actually used in the Discoverer Business Areas, not all tables as in the development instance.

The development instance contains data that is a snapshot of the production data, so that there is information for the Discoverer workbooks to return when developing.

Before new Workbooks & Business Areas can be rolled out to the PRODUCTION instance for actual use, the developers must let the DBA know what additional tables (if any) need grants in order to allow access via Discoverer.

Hope that gives you some ideas.

Todd

----------------------------------------------------------------------
Previous Topic: Re: Display a message when REPORT shows no data
Next Topic: How to Run Reports 3.0 from Forms4.5
Goto Forum:
  


Current Time: Thu Mar 28 07:31:19 CDT 2024