Re: Two DBLINK or not two DBLINK?

Rich,

Okay, if I'm reading your message correctly, I should point out that there is no read-only control over a database link. What you want to do (and maybe this is what you mean) is to create a new schema on each end of the link (or maybe two if you want to separate r/w from r/o). On the originating end, a user can only use the link through that schema. On the terminating end, only the tables and permissions you chose to grant are available. Then you create schemas so users don't have a cumbersome syntax.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l