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.