RE: TOAD Access to other Schemas

  • From: "Brady, Mark" <Mark.Brady@xxxxxxxxxxxxxxxxx>
  • To: <rjamya@xxxxxxxxx>, "William Wagman" <wjwagman@xxxxxxxxxxx>
  • Date: Thu, 14 Jun 2007 16:37:15 -0400

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of rjamya
Sent: Thursday, June 14, 2007 2:24 PM
To: William Wagman
Cc: Christopher.Boyle@xxxxxxxxxxxxx; DENISE@xxxxxxxxxxxxxxxxx;
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.


On 6/14/07, William Wagman <wjwagman@xxxxxxxxxxx> 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

Other related posts: