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
SQL SERVER – Add Failover Cluster Node Fails With Error – This SQL...
In this blog post we will discover how to fix an Add Failover Cluster Node Fails With Error. If you have installed SQL Server cluster, then it would be easy for you to remember that it’s a two-step pr...
Code Tester – Version Control Software
Introduction A common question regarding Code Tester is how it integrates with version control software. More generally, it is important to know how and what one should considering storing in a versio...
How to add Parent Table Name to FK columns at once
There can be various reasons why all primary key attributes in your database structure should be named identically. The most typical name is “ID”. But what if you start creating relationships? In Toa...