public synonyms
views
>On Fri, 27 Aug 1999 12:08:24 GMT, gm_at_offline.no (G. Mjoen) wrote:
>
>>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 Thu Sep 02 1999 - 06:17:06 CDT
