Re: Help with query across schema in TOAD

zwasdl_at_gmail.com schreef:
> Hi,
> I think I didn't describe my questions properly.
> I have two userIDs which can connect to two different Oracle
> Databases.

Misconception #1: it is one database, two schema's!

> I'm trying to join the tables from the two databases. I know
> in MS Access I can do that via linked tables, but I can't write hint in
> query. So I have the following two questions:
> 1. How can I do it in TOAD/Oracle?

Not. Unless you grant access to the tables, owned by A to B: grant select on my_table to b;

B can now: select * from a.mytable;

> 2. How can I add hint in Access in this case? I know pass-through
> query might work, but will face the same issue as in question 1.

Would not know. What is Access?

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...