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
ODC Appreciation Day : Online Move Data File Operation
I've decided to dedicate my ODC Appreciation Day blog post to “Online Move Data File Operation” – a feature which has been introduced in Oracle 12c.As a quick background to this blog post, ODC (Oracle...
Oracle Net8 Components
This section discusses the following Net8 configurations: Dedicated server Multi-threaded server (MTS) Oracle Internet Directory Oracle Names Connection Manager As you read these sections, bear...
