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
Aligning Stakeholders with Iterative Development
Iterative and Incremental Delopment Are you challenged with getting your stakeholders to agree on one requirement? If so, don't feel alone. It's not uncommon as a business analyst to be stuck in the i...
OBIEE 12c (12.2.1.3) post upgrade challenges – unable to save HTML...
Very recently, an OBIEE v12.2.1.1 upgraded to v12.2.1.3 on an Exalytics machine. Though it wasn’t a major upgrade, we had to do it to fix some bugs encountered in v12.2.1.1. For sure, it wasn’t a easy...
The Future of Managing Databases in a Hybrid IT World
When you work in information technology long enough, you get to see how people react when something new comes along. Some people embrace change, even to the point of being an early adopter. Others mig...
