A lot of times people ask “What are the minimum database privilege requirements necessary to use Toad?”
Now that’s a fairly loaded question – since it all depends on your job, Toad usage, and DBA’s viewpoint on grants. For developers to “see” all stored PL/SQL code across schemas using the fewest steps (i.e. the quick & dirty route): 1. Grant them their basic database access rights – for example, the Oracle supplied roles for CONNECT and RESOURCE 2.
