Toad World Blog

Q: Which privileges does the user need to run Toad’s analysis features?

Nov 15, 2014 12:00:00 AM by Chris Reyes

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.

Tags: Toad for Oracle Wiki

Chris Reyes

Written by 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.