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
Troubleshooting and Monitoring Logical Standby Database
This article is focused on how to do troubleshoot the Logical standby database and monitoring the logical standby database apply, In detail we will go through how the SQL Apply process actually works ...
Toad for Oracle – DB Health Check
This video covers new Production, Configuration and Virtualized databases as well as explanation windows & report....
Toad for Oracle – Database Versions Q and A
Questions and Answers on Toad for Oracle Database Versions: Q1: Does Toad support Oracle RDB, Times Ten, or Berkeley DB? A1: The answer is NO to all of these. Essentially, these are all radically di...
