Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get access to a table in another tablespace and database

436307Jan 12 2005 — edited Jan 13 2005

Hi,

I have a database db which includes two tablespaces tb1 and tb2. I can grant select access to a table t in tablespace tb1 so it can be accessed by the tablespace tb2 as follows:

grant select on tb1.t to tb2

Now I would like to create two databases, db1 with tablespace tb1 and db2 with tablespace tb2, but I still would like to use the t table (in tb1 of db1) in tb2 of db2. Is the following syntax correct?

grant select on db1.tb1.t to db2.tb2

Thanks,

Jane

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 10 2005

Added on Jan 12 2005

#general-database-discussions

4 comments

1,083 views