Re: Accessing tables

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Tue, 5 Sep 2000 16:49:39 -0700
Message-ID: <8p40po$osc$1@spiney.sierra.com>

Assuming table T1 in tablespace TS1 owned by user U1 and table T2 in tablespace TS2 (or TS1) owned by a different user U2

as user U1:

SQL> grant select on T1 to U2;

as U2:

select * from U1.T1;

Idea here is that given access privs. on the "other" user's objects, you simply
precede the object's name with the owner's name.

select * from <owner> . <object>.

"Sonia Gillespie" <sonia_gillespie_at_lagan.com> wrote in message news:968074995.22255.0.nnrp-01.9e9859ae_at_news.demon.co.uk...
> Is it possible within Oracle 7.3.4 to access a table located in Tablespace
A
> from another Tablespace B within the same database?
>
> How is this accomplished?
>
> Thanks in Advance,
> Sonia.
> --
> Sonia Gillespie
> E-mail: sonia_gillespie_at_lagan.com
>
>
Received on Tue Sep 05 2000 - 18:49:39 CDT