Re: TOAD Access to other Schemas

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: randyjo@xxxxxxxxxxxxx
  • Date: Thu, 14 Jun 2007 06:50:30 -0400

Other than doing 10046, you know that toad can spool out all its sql to a
sqlfile locally ... right?

Very useful, when we moved to 9i, loading of object browser was dog slow, by
spooling sqls, we found that it was the select from dba_types view that was
taking a really long time.

Raj

On 6/14/07, Randy Johnson <randyjo@xxxxxxxxxxxxx> wrote:

I agree with Tony. One thing you could do is run a 10046 trace on their
session and let them try clicking on a few things they want to do. Then
look
through the trace file to see what TOAD is trying to do in the database.
You
might be able to hone in on exactly which privileges they need using this
approach.

Other related posts: