Problem Viewing Triggers

[hstefan]

I will show all triggers, packages to a group of
people in our company. I gave all of them
a role in the database and granted select
on following tables:
dba_source
dba_objects
dba_triggers
dba_trigger_cols

For all Objects they can see the the Code, but
only the triggers are not displayed. They can
select from dba_triggers and show the trigger_body
manuell but in the schema-browser the triggers are not visible.

Any Idea ??

 

[Marco Kalter]

Perhaps you need to enable the "Use DBA views if available" preference (Tools > Preferences > Oracle/Options)?

 

[hstefan]

I have checked it and the option in
preferences is set.

It seems that there is missing a
system privilege that developer need
for this task. When i grant select_catalog_role
than the triggers are displayed but i
wan't grant this role to the users.