Path: text.usenetserver.com!out03b.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!newscon02.news.prodigy.net!prodigy.net!newsdst01.news.prodigy.net!prodigy.com!postmaster.news.prodigy.com!nlpi069.nbdc.sbc.com.POSTED!89d291a9!not-for-mail From: "Dereck L. Dietz" Newsgroups: comp.databases.oracle.tools References: <5V_Ci.1519$Sd4.1366@nlpi061.nbdc.sbc.com> <46dd07de$0$235$e4fe514c@news.xs4all.nl> Subject: Re: Designer Question Lines: 29 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 X-RFC2646: Format=Flowed; Response Message-ID: NNTP-Posting-Host: 71.144.86.89 X-Complaints-To: abuse@prodigy.net X-Trace: nlpi069.nbdc.sbc.com 1189353112 ST000 71.144.86.89 (Sun, 09 Sep 2007 11:51:52 EDT) NNTP-Posting-Date: Sun, 09 Sep 2007 11:51:52 EDT Organization: AT&T http://yahoo.sbc.com X-UserInfo1: SCSYASVE\JW[C[XYBBCF_P@@GB^NAGDMJ@GZ_GYO^BSZUSAANVUEAE[YETZPIWWI[FCIZA^NBFXZ_D[BFNTCNVPDTNTKHWXKB@X^B_OCJLPZ@ET_O[G\XSG@E\G[ZKVLBL^CJINM@I_KVIOR\T_M_AW_M[_BWU_HFA_]@A_A^SGFAUDE_DFTMQPFWVW[QPJN Date: Sun, 9 Sep 2007 11:51:58 -0400 Xref: usenetserver.com comp.databases.oracle.tools:181517 X-Received-Date: Sun, 09 Sep 2007 11:52:06 EDT (text.usenetserver.com) "Shakespeare" wrote in message news:46dd07de$0$235$e4fe514c@news.xs4all.nl... > > "Dereck L. Dietz" schreef in bericht > news:5V_Ci.1519$Sd4.1366@nlpi061.nbdc.sbc.com... >>I may know the answer but I just thought I'd throw this out in case >>someone more knowledgeable than myself may know a work-around. >> >> Is there a way in designer to set up synonyms for objects in another >> database being accessed through a database link or will things like that >> have to be taken care of manually outside of designer? >> >> > > I think it can be done in the 'distribution' part of Designer. Don't have > one here right now to confirm that. > > Shakespeare > Unfortunately it looks like I can only create SYNONYMS and grant permissions through roles to only objects which are local to the database. So if I want a role to have permissions to objects in the local and remote databases I'm going to have to handle the remote objects manually outside Designer.