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
Toad Data Point – SQL Editor Overview
The SQL Editor combines a powerful SQL and procedure editor into a single interface.The SQL Editor has many advanced features including those that allow you to quickly develop scripts, understand your...
VIDEO TUTORIAL: Toad Advanced Explain Plan Tips and Techniques
Welcome to my new video blog! Our first tutorial: Toad Advanced Explain Plan Tips and Techniques. I hope you find it useful. Drop me a line and let me know if you have any comments or questions. Dan...
Toad Data Point Automation Series: Blog #5 – Using Macros in Excel
For more advanced forms of formatting use Excel macros. Macros are VBA instructions that can be triggered by Toad. By default Excel disables macros. You will need to set up Excel to use macros. When...