Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Thu Jun 14 2007 - 05:50:30 CDT
![]() |
![]() |