How see all trigger and package body ?

I wonder know what I need to view all triggers and package bodies. Without grant DBA. I already grant SELECT ANY DICTIONARY, SELECT ANY TABLE and SELECT_CATALOG_ROLE
 
Maybe you could try changing your setting for "Use DBA Views if available" (Tools-->Preferences-->Oracle-->Options)
 
Back
Top