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
Guide to using Toad Data Point Workbook
Toad Data Point Workbook is a feature added in Toad Data Point version 5.0 and is available to Toad Data Point Professional users. Toad Data Point Workbook offers an alternative to the traditional T...
Server Pools: What’s New in Oracle 12c?
Overview Oracle Clusterware 11g release 2 laid the foundation of policy-based cluster management by introducing server pools, which are logical groups of servers hosting the resources managed by Orac...
How to compare multiple database schemas in Toad Data Studio
In this tutorial video we will learn how to compare multiple database schemas using Toad Data Studio. Toad 1.0 Beta Release offers a homogeneous schema compare supporting multiple data sources incl...
