Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g5R1fS122782 for ; Wed, 26 Jun 2002 21:41:28 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id KAA87470; Wed, 26 Jun 2002 10:40:03 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b71/bab) via UUCP id 004890A4; Wed, 26 Jun 2002 10:30:15 -0800 Message-ID: Date: Wed, 26 Jun 2002 10:30:15 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Deshpande, Kirti" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Deshpande, Kirti" Subject: RE: privileges and synonyms and dblinks Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C21D35.ED8E18A0" ------_=_NextPart_001_01C21D35.ED8E18A0 Content-Type: text/plain; charset="iso-8859-1" Matt, We have run in to this issue. There are some bugs related to this. Pl review docs on Metalink # 159051.1, # 144114.1. - Kirti -----Original Message----- Sent: Wednesday, June 26, 2002 11:03 AM To: Multiple recipients of list ORACLE-L All of a sudden this is not making sense to me. Oracle 8.1.7.3 on HP-UX 11i I have a public db link (link1) I have a user (user1) who creates a PRIVATE synonym. (user1.syn1) that points to a table on the other database using the dblink. User2, having ONLY the CONNECT role, cannot do a describe of user1.syn1, but CAN issue a 'select * from user1.syn1' and get data back. I know that since the db link is public with a account/password, he could get the data anyway by, but what I can figure out is why it resolves the synonym at all when it is private? Am I missing something here? ---- Matt Adams - GE Appliances - matt.adams@appl.ge.com "Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi." - Larry Wall (creator of Perl) ------_=_NextPart_001_01C21D35.ED8E18A0 Content-Type: text/html; charset="iso-8859-1" privileges and synonyms and dblinks
Matt,
 We have run in to this issue.
 There are some bugs related to this.
 Pl review docs on Metalink # 159051.1, # 144114.1.
 
- Kirti
-----Original Message-----
From: Adams, Matthew (GEA, MABG, 088130) [mailto:MATT.ADAMS@APPL.GE.COM]
Sent: Wednesday, June 26, 2002 11:03 AM
To: Multiple recipients of list ORACLE-L
Subject: privileges and synonyms and dblinks

All of a sudden this is not making sense to me.

Oracle 8.1.7.3 on HP-UX 11i

I have a public db link (link1)

I have a user (user1) who creates a PRIVATE synonym.
(user1.syn1) that points to a table on the other database
using the dblink.

User2, having ONLY the CONNECT role, cannot
do a describe of   user1.syn1, but CAN
issue a 'select * from user1.syn1' and get data
back.  I know that since the db link is public with
a account/password, he could get the data anyway by,
but what I can figure out is why it resolves the synonym
at all when it is private?

Am I missing something here?



----
Matt Adams - GE Appliances - matt.adams@appl.ge.com
"Doing linear scans over an associative array is like
trying to club someone to death with a loaded Uzi."
    - Larry Wall (creator of Perl)

------_=_NextPart_001_01C21D35.ED8E18A0-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: kirti.deshpande@verizon.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).