Print Thread
How see all trigger and package body ?
#29956 05/13/08 08:04 PM
Joined: May 2008
Posts: 6
Colombia
I
Member
OP Offline
Member
I
Joined: May 2008
Posts: 6
Colombia
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

Re: How see all trigger and package body ?
#29957 05/13/08 09:46 PM
Joined: Feb 2006
Posts: 619
Sao Paulo, Brazil
G
Member
Offline
Member
G
Joined: Feb 2006
Posts: 619
Sao Paulo, Brazil
Maybe you could try changing your setting for "Use DBA Views if available" (Tools-->Preferences-->Oracle-->Options)


There are 10 types of people: those who know binary and those who don't.

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.042s Queries: 14 (0.006s) Memory: 2.4936 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-03-29 15:02:25 UTC
Valid HTML 5 and Valid CSS