Re: TOAD Access to other Schemas

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_at_sbcglobal.net> 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.
>

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