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.
Q: Which privileges does the user need to run Toad’s analysis features?
