Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Two DBLINK or not two DBLINK?

Re: Two DBLINK or not two DBLINK?

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Fri, 15 Dec 2006 12:54:26 -0600
Message-ID: <de807caa0612151054h7fe724e8k51005f31ca4a4213@mail.gmail.com>


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
Received on Fri Dec 15 2006 - 12:54:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US