Cross schema / user dependencies

[Valgardur]

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]

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]

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]

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]

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