Referenced by

[DoDo]

In version 8 when I clicked on Referenced by branch in Object browser it displayed all referencing objects regardless of an referencing object owner, but in version 9 it does not.

For example:

Schema "MyTables" is owner of table "first_table"
and has granted referencing on it to schema "MyTriggers"
which has trigger "first_trig" created on table "first_table".

When we are connected as "MyTables" trigger is not in "Referenced by", but when we connect as "MyTriggers" it is.

Object browser filters, in both cases, are set to and All objects.

This is big deal, because now I can not rely on PL/SQL Developer to show me who references my tables.

Please return old behaviour!

 

[Marco Kalter]

This is the same in 8.0 and 9.0. You may need to enable the "Use DBA Views is available" preference (Tools > Preferences > Oracle / Options). Triggers owned by other users will only be visible in the DBA views.

 

[DoDo]

I tried "Use DBA Views is available" before I reported the problem.
But this is so strange:

I was mistaken, I can see triggers (strange) but can't see packages or package bodies that references "first_table".

I do not know from which view you select if user can't see "DBA Views", but if you select from ALL_DEPENDENCIES there is strange behaviour of that view, it shows triggers, procedures, functions and synonyms but not packages or package bodies of other users.

But, If I connect as user which can see DBA_DEPENDENCIES i can see packages and package bodies, but also, I can see them through ALL_DEPENDENCIES; so option in preferences "Use DBA Views is available" has no impact at all in that case.

This all is also true in version 8 of pldev.

I have Oracle 10gR2 database.

Is this some kind of Oracle bug?

 

[Marco Kalter]

PL/SQL Developer will use ALL_DEPENDENCIES or DBA_DEPENDENCIES based on the "Use DBA Views is available" preference. Only objects reported in these views will be displayed in the "References" and "Referenced by" folders.