Ways to fake table in own scema.

I have a user (USER1) with a lot of tabes. I created a new user (USER2) with no tables in his/hers schema. USER2 is granted select on all of USER1's tables.

The problem is:

USER2 needs to write 'select * from USER1.TABLE1' instead of 'select * from TABLE1'.

I am able to fix this by creating a synonym for each table. Is there som other way of doing this?

--
Gaute Received on Fri Aug 27 1999 - 07:08:24 CDT