You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by Robert Morse <rm...@mdesignz.com> on 2003/02/17 23:42:55 UTC
Oracle - Accessing other users tables
The pre-existing database that I'm working with has tables owned by
various users. How do I specify in the project-schema.xml file which
user owns the table?
Here's an example: Let's say I'm USER1, but I want to select rows from a
table owned by USER2.sample_table. USER2 has granted me SELECT rights
to the table.
My SQL query would need to be SELECT test from USER2.SAMPLE_TABLE.
I'm guessing that I could define the table_name as USER2.SAMPLE_TABLE,
but I was wondering if there is a different way.
Thanks.
--
"All motion is not progress, and all movement is not forward" (anon)
Key ID: F0533BB6
Finger Print: 7F07 D9CD 266F 29D4 3616 164D F055 6E4C F053 3BB6
Re: Oracle - Accessing other users tables -- NEVERMIND
Posted by Robert Morse <rm...@mdesignz.com>.
Sorry for the noise. Using Oracle synonyms accomplishes what I need.
On Mon, 2003-02-17 at 14:42, Robert Morse wrote:
> The pre-existing database that I'm working with has tables owned by
> various users. How do I specify in the project-schema.xml file which
> user owns the table?
>
> Here's an example: Let's say I'm USER1, but I want to select rows from a
> table owned by USER2.sample_table. USER2 has granted me SELECT rights
> to the table.
>
> My SQL query would need to be SELECT test from USER2.SAMPLE_TABLE.
>
> I'm guessing that I could define the table_name as USER2.SAMPLE_TABLE,
> but I was wondering if there is a different way.
>
> Thanks.
>
>
>
> --
> "All motion is not progress, and all movement is not forward" (anon)
> Key ID: F0533BB6
> Finger Print: 7F07 D9CD 266F 29D4 3616 164D F055 6E4C F053 3BB6
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
--
"All motion is not progress, and all movement is not forward" (anon)
Key ID: F0533BB6
Finger Print: 7F07 D9CD 266F 29D4 3616 164D F055 6E4C F053 3BB6