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
Does Toad for Oracle have a ‘convert to ANSII’ function?
Yes. In Editor, right-click and choose Refactor: convert to/from ANSI join. The query builder also offers this functionality. For example, you can send Editor contents to the query builder to "see" yo...
Toad for Oracle Data Grid – What is the OCI Buffer Array Size option...
After a SELECT query is executed, we must retrieve the rows from the Oracle server to your PC. We do not retrieve the rows all at once, nor do we retrieve them one at a time (unless there is a LONG or...
Lucky Breaks While Performance Tuning Oracle
Hi, This article will include a couple of great tips…one using a hint I work with in my SQL Tuning class and the other solving a performance issue with partitioning using PL/SQL Dynamic Execute Immedi...
