A: Not necessarily. Actually, we recommend that, instead of the DBA role, you grant discrete privileges; that grants everything! Within Toad, we try to use USER_ and/or ALL_ where possible, but a few things like tablespaces only offer DBA_ views. In those cases, all you would need is the SELECT_ANY_CATLOG role.
Related Articles
Toad for Oracle – GUI Q&A
Q: How do I change my connection color? A: In Toad for Oracle 11: Click on a connection in the log-in window. Scroll over to the Color column. Click within that field to access the list of colors. ...
Run Oracle Scripts (Even against Multiple Databases) in the Toad Script...
If your IT department or development team is like a lot of those I talk with (and have worked in), you have a lot of scripts that do all sorts of things. They are important to you, and that’s why yo...
100% Correct Cost Estimation Leads to the Best SQL Optimization – 10...
This blog is the finale in this series about common misconceptions surrounding SQL tuning. I selected this topic as my last one because it is a very common misconception in a DBA or developers mind. I...