Path: text.usenetserver.com!out01b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!news2.google.com!news.glorb.com!newshub.sdsu.edu!newscon04.news.prodigy.net!prodigy.net!newsdst01.news.prodigy.net!prodigy.com!postmaster.news.prodigy.com!newssvr23.news.prodigy.net.POSTED!89d291a9!not-for-mail From: "Dereck L. Dietz" Newsgroups: comp.databases.oracle.server Subject: Role/Privilege and remote databases Lines: 28 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; Original Message-ID: NNTP-Posting-Host: 71.144.86.89 X-Complaints-To: abuse@prodigy.net X-Trace: newssvr23.news.prodigy.net 1189361336 ST000 71.144.86.89 (Sun, 09 Sep 2007 14:08:56 EDT) NNTP-Posting-Date: Sun, 09 Sep 2007 14:08:56 EDT Organization: AT&T http://yahoo.sbc.com X-UserInfo1: TSUGG\CDPBSGCTXXNKK^_T\B\JYL@DHLLBWLOOAFEQR@ETUCCNSKQFCY@TXDX_WHSVB]ZEJLSNY\^J[CUVSA_QLFC^RQHUPH[P[NRWCCMLSNPOD_ESALHUK@TDFUZHBLJ\XGKL^NXA\EVHSP[D_C^B_^JCX^W]CHBAX]POG@SSAZQ\LE[DCNMUPG_VSC@VJM Date: Sun, 9 Sep 2007 14:09:02 -0400 Xref: usenetserver.com comp.databases.oracle.server:434664 X-Received-Date: Sun, 09 Sep 2007 14:09:02 EDT (text.usenetserver.com) Oracle 10.2.0.3, Windows 2003 Server Below is the scenario. I'm confused about roles and permissions when using more than just a local database. Is the question at the end of the scenario correct? remote_server my_schema.my_table - GRANT SELECT, INSERT, UPDATE ON my_schema.my_table TO MY_ROLE my_role - user1 - user2 local server CREATE PUBLIC SYNONYM my_table FOR my_schema.my_table@remote_server my_role - user3 Q: Is having the MY_ROLE role on both the remote and local server, and granting privileges to the role sufficient to allow USER3 to access the MY_TABLE on the remote server?