Re: Read only links to other databases

create a new user with select only rights on tables in PRODUCTION and take this user for creation of a public database link from DEVELOP to PRODUCTION. the developers can access then the PRODUCTION data via

select ... from TABLENAME_at_DATABASELINKNAME

cheers,
lorenz

aparansk_at_westernasset.com schrieb in Nachricht <71nhcb$pkr$1_at_nnrp1.dejanews.com>...
>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?
>
>Thanks.
>-AP_
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Nov 03 1998 - 13:14:53 CST