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
Oracle Hybrid Database Cloud using Enterprise Manager – Part XX
Hybrid Cloud management is an interestingly hot topic for today’s cloud world, since not all companies want to move everything to the cloud. In this article series, we are looking at the detailed step...
Blocking and Tackling on Agile Projects
Chickens, Pigs, and Goats How's your luck in controlling all the animals on a scrum? If you're familiar with scrum projects, I'm sure you've heard the story of the chicken and the pig who considered ...
Minimize Risk by Simplifying and Automating Oracle Code Testing
As I work with database management and application development pros at all types and sizes of organizations, I’ve been looking for trends in database code testing – unit testing of PL/SQL functions an...
