RE: TOAD Access to other Schemas

Toad now dynamically figures out Is ALL_ or DBA_ is available and stores that for use in every query where there is an ALL_ or DBA_ choice... of course not every DBA_ has an analog and Toad tends to choke then.  

As far as Sql Navigator, When I evaluated it about a year ago, I couldn't even connect to a database UNLESS AND UNTIL it ran a 'server-side script' to create a new user. Whereas in Toad you can do most everything without a Toad Schema. I complained to Embarcadero and they said, "Gee, why can't your developers make schemas in Dev."  

I can see how someone un-oracle-initiated would see that as requiring DBA access.  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of rjamya Sent: Thursday, June 14, 2007 2:24 PM
To: William Wagman
Cc: Christopher.Boyle_at_multiplan.com; DENISE_at_wvnvaxa.wvnet.edu; oracle-l_at_freelists.org
Subject: Re: TOAD Access to other Schemas  

AFAIK there is an option in TOAD where you tell TOAD to look for ALL_ views instead of DBA_ views. at-least it was in 7.x.

Raj

On 6/14/07, William Wagman <wjwagman_at_ucdavis.edu> wrote:

I suspect that may be all that is necessary in TOAD as well although I don't know.    

Bill Wagman said:  

A few years ago one of the development groups here started using SQL Navigator. When first implemented they were unable to perform many tasks because they didn't have enough access despite specific access having been granted to objects in other schemas on an as needed basis. The immediate request (demand actually) was to grant DBA access.

>>> This e-mail and any attachments are confidential, may contain legal, professional or other privileged information, and are intended solely for the addressee. If you are not the intended recipient, do not use the information in this e-mail in any way, delete this e-mail and notify the sender. CEG-IP1

--
http://www.freelists.org/webpage/oracle-l