Not able to view triggers from non-owner schema

[rutherford]

In version 9.0.2.1621 of PL/SQL Developer I am not able to view triggers from non-owner schemas.

Steps to reproduce -

1. Create table and trigger in schema A
2. Grant DEBUG on table to schema B
3. Confirm trigger is visible in all_triggers from schema B (select * from all_triggers where owner = 'SCHEMAA')
4. Observe that the "Triggers" folder in the object browser is empty.

What should happen -

1. Trigger and definition should be available in the "Triggers" folder.

 

[Marco Kalter]

Is the trigger also visible in the all_objects view?

 

[rutherford]

No, the triggers are not listed in all_objects. However, you can find their source in all_source and their metadata in all_triggers.

Is it possible for PL/SQL Developer to key off all_source for functions/packages/etc to handle the DEBUG grant, or is the only solution to get access to the DBA data dictionary tables if I wish to view these objects in the PL/SQL object browser?

 

[Marco Kalter]

The only solution is to obtain select privileges on dba_objects and to enable the "Use DBA views if available".

 

[rutherford]

For what it's worth, we were running a 10.2.0.1 database; after upgrading to 10.2.0.5 objects given "grant debug" show up in all_objects as expected making this no longer an issue.