Re: Read only links to other databases

Hi,

Try

create database link prod
 connect to someuser identified by somepassword using 'prod';

Someuser is not an owner of production schema. He is separate user of production database only with select privileges on necessary production tables. Then it is possible to perform on development database

select * from productionuser.sometable_at_prod;

Andrew Protasov

> 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?
Received on Wed Nov 04 1998 - 01:51:44 CST