Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Selecting data from other user's schema: Best way to eliminate table owner?
There is an undocumented feature that will do this:
alter session set current_schema = xxxxx; (no quotes)
Doug
Thomas Greuter <grth1_at_zh.swissptt.ch> wrote in article
<01bc7655$d4537bf0$62d5bb8a_at_tzhi95>...
> What is the best way of easy selecting data from an other user's schema?
> ...
> We used synonyms to break down the schema-barrier:
> create public synonym PRODS for ABC_MGR.PRODS; (as system)
> and all the TZHusers may do theirs selects without knowing about ABC_MGR.
>
> Q: Is this a common way in Oracle? If no, are there some other ways to
> eliminate the table/schema owner we didn't see?
Received on Fri Jun 13 1997 - 00:00:00 CDT