Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to see triggers.

user526179Feb 8 2007 — edited Mar 12 2007
I'm running sql developer 1.0 and 1.1 and if I browse to other users and try to see if there are any triggers, nothing is showing up. So for production support users trying to see if the code of a trigger matches the code of a trigger in dev they cannot. We cannot grant create any trigger and we cannot give them the ability to log in as the object owner. Is there any work around. I noticed that the query being issued is against all_triggers, is there a way to switch it to dba_triggers or have the tool use dba_tables?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2007
Added on Feb 8 2007
4 comments
3,438 views