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.

About the Author

Chris Reyes

Chris Reyes previously worked for Quest and Dell managing the Toad World site and Program Management for various Toad applications. In my spare time, I like to play vintage base ball (1880's rules) and do 3D printing.

Start the discussion at forums.toadworld.com