Re: create database link with 'view only' privilages

From: Sergey Popov <sspopov_at_yahoo.com>
Date: 10 Sep 2001 12:32:47 -0700
Message-ID: <e4ed9a2b.0109101132.b3ec059@posting.google.com>

andreyNSPAM_at_bookexchange.net (NetComrade) wrote in message news:<3b9cd281.422526450_at_news.globix.com>...
> is there are a way to do this?
>
> I need to create a 'staging' database which would point to a central
> reg database, but I'd like to make sure that staging database makes no
> changes to the central database.
>

Hi!

You can create a user account for the targer database with ONLY select privileges and then create the database link using it.

Sergey Popov
Sr. Oracle DBA
NPC
Louisville, KY. Received on Mon Sep 10 2001 - 14:32:47 CDT