When you are connected to Oracle and you reference a table, a view ...
without specifying the object owner, Oracle will use the object as
defined in your schema, and failing that, it will use an object for
which there is a synonym and for which you have been granted access.
You can overide this by specifying the object owner in the reference
(i.e. Select * from somebodyelse.employee).
When you get into using procedures/packages/functions, this logic has
variations to take into account the point of view of the account using
the piece of code, vs the account who compiled that piece of code.
There is lots of information on this subject if you care to read up on
it.
Received on Tue Jan 25 2005 - 15:45:32 CST
