I have users tom and jerry.
All data is stored in tom's schema.
jerry gets access to tom's schema by GRANTs.
Now if jerry wants to access the table "cheese" he has to write "tom.cheese" or he can use a synonym "cheese" that points to "tom.cheese" as well.
If there are lots of tables, I have to create lots of synonyms. Is there an easier way to achieve this? Some kind of "global prefix" that, whenever I specify a table name, implicitly add prefix "tom."?
Or are there other technologies that could be helpful?