Re: Schema name in SQL statement

From: Paul-Marc Marot <Paul-Marc.Marot_at_capway.com>
Date: Thu, 21 Jan 1999 16:12:26 +0100
Message-ID: <787fsa$5g5$1@minus.oleane.net>

Omer Eisenberg a écrit dans le message <36A73A00.EDE67E26_at_nist.gov>...
>Hi All,
>I'm quite new to Oracle, so forgive me if this question is silly.
>The only way I found for one user, say USER1, can access tables and
>views owned by another users, say USER2, is to put the schema name in
>the SQL statement, e.g.:
> SELECT * FROM USER2.TABLE1
>Am I right about this, or is there a way to avoid including the schema
>name?
>Thanks in advance,
>Omer Eisenberg.
>
>

Create a synonym

Paul-Marc

---

"In the beginning there was data. The data was without form and null. And darkness was upon the face of the console; and the spirit of IBM was moving over the face of the market. And DEC said "Let there be registers";
and there were registers. And DEC saw what they carried; and DEC separated the data from the instructions;
and DEC called the data Stack and the instructions they called Code. And there was evening and there was morning, one interrupt..." -- Rico Tudor Received on Thu Jan 21 1999 - 09:12:26 CST