Here's our Szenaio:
Oracle 10.2.0.1
2 Schemata: Scheme1 and Scheme2
Table owner is Scheme1
Scheme2 has neither tables noe views, he shall only work on views and tables within Scheme1, but the don't want to use the syntax Scheme1.<View_Name>.
They want to use only select * from viewx.

Is this posible if we grant all necc. priviliges (eg. select on Scheme1.viewx) and the query from Scheme1 and Scheme2 could be the same query (select * from viewx).

I told them to use select * from Scheme1.viewx for any users - but they want to have it without.