Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!s16g2000cws.googlegroups.com!not-for-mail
From: thtsang_yh@yahoo.com.hk
Newsgroups: comp.databases.oracle.server
Subject: Object Privilege for Database Link?
Date: 7 Jul 2006 00:40:09 -0700
Organization: http://groups.google.com
Lines: 19
Message-ID: <1152258009.177590.75830@s16g2000cws.googlegroups.com>
NNTP-Posting-Host: 202.66.19.11
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1152258014 7558 127.0.0.1 (7 Jul 2006 07:40:14 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 7 Jul 2006 07:40:14 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.10) Gecko/20050716 Firefox/1.0.6,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 proxy.belton.com.hk:3128 (squid/2.5.STABLE12)
Complaints-To: groups-abuse@google.com
Injection-Info: s16g2000cws.googlegroups.com; posting-host=202.66.19.11;
   posting-account=ap7OowwAAAC5WwGO1az094-U10P3MlV0
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:270544

I would like to allow a schema to access a remote database through a DB
link created by another schema. However, it seems there is no object
privilege for db links, so that I can't assign the right to that
schema. As an example, what I want is something like

(From Schema 1)
create database link dblink1...;
grant execute on dblink1 to schema2;

(From Schema 2)
select * from table_name@schema1.dblink1;


I know a public database link can be shared among different schemas.
However, I don't want to allow everyone to access the remote db through
the db link, but only selected schemas.

Am I missing something? Or this cannot be done yet?