Toad World Blog

Q: To use the session browser or top session finder, do you have to be in a DBA role?

Nov 14, 2014 11:00:00 PM by Chris Reyes

A: Not necessarily. Actually, we recommend that, instead of the DBA role, you grant discrete privileges; that grants everything! 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.

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.