Re: Accessing another user's table without qualifying table name with the owner-name

In article <6euddu$qan$3_at_vnetnews.value.net>, twod_at_not.valid writes
>Atul Deshmukh (atul_at_emessages.com) wrote:
>
>: How is it posssible to access another user's table without qualifying table
>: name with the owner-name.
>
>Synonyms. Read up on the difference between private and public synonyms.
>
>: One of the ways would be to create a public synonym for User1.Table1 and
>: then grant access to that synonym for "User2". Using this scheme, "User2"
>: can issue an SQL statement such as "Select * from public_user1_table". But
>: in our scenario that solution is not feasible since all other users will
>: also be able to access this public synonym. Is there any other way to
>: accomplish the same thing?
>
>Private synonyms. User2 has a (set of) private synonym(s) that resolve to
>user1's table(s).
>

Alternatively (undocumented AFAIK):

alter session set current_schema = <other_user>;

Hope this helps.

-- 
Paul Brewer