Accessing Table of other owner

[jmodic]

You have two options (apart the one mentioned by jovery):

- create PUBLIC synonyms for that tables (so you'll have only 250 synonyms, not 2500)
- allow your users to perform the following : ALTER SESSION SET CURRENT_SCHEMA = USER1;