Re: database links

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 18 Nov 1999 00:39:30 -0800
Message-ID: <3833BB42.6933CDE9@us.oracle.com>

The database link is really only a way of connecting two databases. The privileges that can be used across the database link (SELECT, UPDATE etc.) are the privileges of the user you connect as. So if you want a read only database link, connect to a user that only has SELECT access.

HTH. Pete

Nandakumar wrote:

> hi
>
> Could someone advise if there are READ ONLY Database links in ORACLE
> 8.0.5?
> thanks
> NAnda
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Received on Thu Nov 18 1999 - 02:39:30 CST