Cross schema / user dependencies

Cross schema / user dependencies

Postby Valgardur » Fri 08 Nov 2013 11:55

Is it possible to get a list of all objects using a selected object across shemas / users?

For example.. to be able to get a list of all procedures, packages, views that refer to a selected table, not just the current user.

If not I would like to suggest this as a feature.
Valgardur
 
Posts: 164
Joined: Tue 24 Nov 2009 19:33

Re: Cross schema / user dependencies

Postby alexa » Fri 08 Nov 2013 13:16

Please note that there are the 'Depends On' and 'Used By' nodes in the tree if you expand an object in Database Explorer. In these collections you can find the object's references and dependants.
alexa
Devart Team
 
Posts: 2175
Joined: Fri 24 Jun 2011 14:17

Re: Cross schema / user dependencies

Postby Valgardur » Fri 08 Nov 2013 14:52

I know, but as far as I can tell, only within the current schema. Perhaps dependant on rights, but in any case, I cannot see the owner / schema in the "used by" list.
Valgardur
 
Posts: 164
Joined: Tue 24 Nov 2009 19:33

Re: Cross schema / user dependencies

Postby alexa » Mon 11 Nov 2013 10:50

Could you please provide us a concrete example of this and describe the steps to reproduce this issue in details?

The scripts of the users and objects will be also of help.
alexa
Devart Team
 
Posts: 2175
Joined: Fri 24 Jun 2011 14:17

Re: Cross schema / user dependencies

Postby Valgardur » Tue 12 Nov 2013 12:26

Thanks, but the problem seems to have been incorrect privileges / grants.
Valgardur
 
Posts: 164
Joined: Tue 24 Nov 2009 19:33


Return to dbForge for Oracle