Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Role/Privilege and remote databases
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