Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Role/Privilege and remote databases

Role/Privilege and remote databases

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Sun, 9 Sep 2007 14:09:02 -0400
Message-ID: <YEWEi.8761$924.1057@newssvr23.news.prodigy.net>


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

 my_role

local server

 CREATE PUBLIC SYNONYM my_table FOR my_schema.my_table_at_remote_server

 my_role

Received on Sun Sep 09 2007 - 13:09:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US