db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Morse <rmo...@mdesignz.com>
Subject Re: Oracle - Accessing other users tables -- NEVERMIND
Date Mon, 17 Feb 2003 23:10:08 GMT
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



Mime
View raw message