A: Aside from privileges to connect, of course, some of the Schema Browser features might require access to the Data Dictionary views. 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. If you are going to create database objects, write PL/SQL code, debug PL/SQL code and profile PL/SQL code. Then you will need whichever database privileges make sense for that task (for example, CREATE PROCEDURE and DEBUG CONNECT SESSION). Toad does NOT require the DBA role or anything excessive; just grant discrete privileges based on what people need to do.
Identity Security Risk Assessment
Get a free AD security assessment to evaluate your environment and identify the most actionable issues.
Related Articles

DB2 for z/OS: Running REORG to Reclaim Disk Space
Think of why you run the DB2 for z/OS REORG utility, and a number of reasons are likely to come quickly to mind: to restore row order per a table's clustering key; to reestablish free space (for inser...

18c is now available (but only on the Cloud)
On Friday afternoon (16th February) we started to see tweets and blog posts from people in Oracle saying that Oracle 18c was now available. But is only available on Oracle Cloud and Engineered Systems...

Benchmark Factory for Databases – What is Scalability Testing?
In this Benchmark Factory video we explain what is database workload and scalability testing....