Re: Two DBLINK or not two DBLINK?

  • From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
  • To: Rich.Jesse@xxxxxx
  • Date: Fri, 15 Dec 2006 12:54:26 -0600


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

Other related posts: