Cross schema / user dependencies

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
Valgardur
Posts: 164
Joined: Tue 24 Nov 2009 19:33

Cross schema / user dependencies

Post by 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.

alexa
Devart Team
Posts: 2428
Joined: Fri 24 Jun 2011 14:17

Re: Cross schema / user dependencies

Post by 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.

Valgardur
Posts: 164
Joined: Tue 24 Nov 2009 19:33

Re: Cross schema / user dependencies

Post by 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.

alexa
Devart Team
Posts: 2428
Joined: Fri 24 Jun 2011 14:17

Re: Cross schema / user dependencies

Post by 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.

Valgardur
Posts: 164
Joined: Tue 24 Nov 2009 19:33

Re: Cross schema / user dependencies

Post by Valgardur » Tue 12 Nov 2013 12:26

Thanks, but the problem seems to have been incorrect privileges / grants.

Post Reply