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

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).

IAP

--
I am using anti-spam measures, please replace 'not.valid' with 'value.net'