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
Instalación de la Base de Datos Oracle 11gR2 en Windows
En este artículo quiero compartir la instalación de la Base de Datos Oracle 11gR2 muy simple en Windows. Descargamos la base de datos Oracle desde OTN, para ello necesitamos tener un usuario y acepta...
Toad Turnpike: Real Stories from the Road – Interruptions Part 3
Real stories. Real people. Doing real things. With Toad solutions. Impasse at Auditor Junction “What a nightmare…get me out of this day!” This is not a good day for a customer visit. Everything is go...
Oracle Coding Best Practices – Part 2
Hi, This month I’ll focus on a couple of PL/SQL performance tips that will include how to utilize collections to radically increase row processing and a simple but useful coding tip on the benefits an...
