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
Overview of developer features in Toad for DB2 – Part X
This video on SQL tuning for DB2 on z/OS is part ten of an overview of developer features in Toad for DB2....
What are the GDPR rules and how do these apply to the DBA?
Today I’m going to talk about the new GDPR rules, how they might affect your company, and steps DBAs can take to ensure compliance. The General Data Protection Regulation (GDPR) is now in effect, re...
Oracle CREATE TABLE Syntax
Oracle V11.1 Description Example >>──CREATE─┬──────────────────┬─TABLE──schema.──table──┬─relational_table─┬─> └─GLOBAL TEMPORARY─┘ ├─object_table─────┤ ...
