| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Read only links to other databases
A copy of this was sent to aparansk_at_westernasset.com
(if that email address didn't require changing)
On Tue, 03 Nov 1998 18:17:48 GMT, you wrote:
>We have two instance of Oracle databases running in our company. One is
>PRODUCTION and the other is DEVELOPMENT. The DEVELOPMENT database does not
>have the latest data which is in PRODUCTION.
>
>I know that we can create a "link" between DEVELOPMENT and PRODUCTION in
>order to be able to SELECT from PRODUCTION and INSERT into DEVELOPMENT tables
>for the purpose of updating data in DEVELOPMENT.
>
>Is there a way to make this link READ-ONLY so that developers in DEVELOPMENT
>cannot change anything in PRODUCTION? Are there other solution to allow
>developers to get the latest data from PRODUCTION, but not have any access to
>change the data?
>
if you create the database link with a username/password (a proxy link) and then grant CONNECT and SELECT only to that username in the remote database, the db_link will be 'read only' in that the user can only connect to the database and SELECT from some tables....
>Thanks.
>-AP_
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Nov 03 1998 - 12:48:43 CST
 |
 |